SQLAlchemy and Alembic 2 · Querying
Avoid N+1 queries
Load related rows in the same query or one extra query, instead of one query per object.
from sqlalchemy.orm import selectinload
users = session.scalars(select(User).options(selectinload(User.posts))).all()
Official SQLAlchemy and Alembic 2 documentation