SQLAlchemy 2.0 Reference: Mapped, select, Relationships, Async and Alembic

SQLAlchemy 2.0 reference — the patterns that actually matter. session.query() is legacy — use select() # Old (SQLAlchemy 1.x): users = session.query(User).filter(User.email == "alice@example.com").all() # New (SQLAlchemy 2.0): stmt = select(User).wh...