How to map query results to objects?

[tdoan2010]

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 sqlmodel import Field, SQLModel, Session, col, select
from sqlalchemy import func


class Person(SQLModel, table=True):
    id: int | None = Field(default=None, primary_key=True)
    first_name: str
    last_name: str
    age: int | None = None


# Note: this is NOT a table
class QueryResult(SQLModel):
    full_name: str
    person_age: int | None = None


with Session(engine) as session:
    query = (
        select(
            func.concat(Person.first_name, Person.last_name).label('full_name'),
            col(Person.age).label('person_age')
        )
        .select_from(Person)
    )
    results = session.exec(query).all()
    print(results)

Description

Supposed that I have 2 models, Person for a table and QueryResult to map the result. A simple query is to select some people and concatenate their first and last name into name.

The results is a list of tuples. However, I want it to be a list of QueryResult. I've made sure that the label and field names are matched. But what else do I need to do to map the result to the defined class?

I know that I can do it manually by looping through the results, but it does not feel right to me. SQLAlchemy or SQLModel must have a solution for this, or?

Operating System

macOS

Operating System Details

No response

SQLModel Version

0.0.22

Python Version

3.11.4

Additional Context

No response

[YuriiMotov]

Validate results with QueryResult model.
Something like

res = [QueryResult.model_validate({"full_name": row[0], "person_age": row[1]} for row in results)]

[tdoan2010]

Thanks for your answer. Is the method model_validate documented somewhere? I couldn't find it.

[YuriiMotov]

I think no, but it works similar to Pydantic's model_validate: https://docs.pydantic.dev/latest/api/base_model/#pydantic.BaseModel.model_validate

[tdoan2010]

I see. Thank you for the information 👍