Model in one-to-many relationships

[Edison985]

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 Session, select
from sqlalchemy.orm import selectinload

from app.models.registro.entidad.modelo_entidad import Entidad, EntidadCreate, EntidadUpdate

class EntidadService:
    def __init__(self, db: Session):
        self.db = db

    def listar_entidad(self, tipo: int):
        statement = select(Entidad).where(Entidad.ent_idtipoentidad == tipo)
        return self.db.exec(statement).all()

Description

It turns out that to display related data from another table I have to use selectinload() for lazy loading and not make the slow request when there is too much data. In SQLAlchemy it is imported with from sqlalchemy.orm import selectinload. But I am going to do the same in SQLModel and that method does not work, only the join() appears. I fully understand that SQLModel is a base model built on top of SQLAlchemy, but it would be great if they integrated that method, it helps a lot.

Operating System

Windows

Operating System Details

Windows 11 HOME

SQLModel Version

0.0.14

Python Version

3.13.1

Additional Context

No response