Query results include aliased models, but result._mapping does not

[etash47]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from sqlalchemy.orm import aliased
...
    AliasA = aliased(ModelX)
    AliasB = aliased(ModelX)
    query = (
        select(
            ModelY,
            AliasA,
            AliasB,
            ModelZ,
        )
        .where(ModelY.field == value)
        .outerjoin(
            AliasA,
            AliasA.id == ModelY.some_other_field,
        )
        .outerjoin(
            AliasB,
            AliasB.id == ModelY.another_field,
        )
        .outerjoin(
            ModelZ,
            ModelZ.id == ModelY.a_different_field,
        )
    )

    results = session.exec(query).all()

    for result in results:
        mapping = result._mapping
        print(mapping) # RMKeyView(['ModelY', 'ModelZ'])
        print(result) # (ModelY(...), ModelX(...), ModelX(...), ModelZ(...))

Description

Here we are adding two aliases to the same Model in sqlmodel and selecting both in the query. The query seems to run properly since the result shows ModelX (the aliased model) in the results. However, result._mapping, which generally returns a dictionary-like mapping from each selectable name to the selected model/field, does not include the aliased models. The example code should hopefully show this clearly, but happy to provide more context if need be.

I can't find anything that would show this is as a sqlalchemy issue since the query is running properly, just ._mapping is not. However, I am using aliased from sqlalchemy.orm

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.21

Python Version

3.12.2

Additional Context

No response