SQLAlchemy 2.0 — Async Patterns

Modern SQLAlchemy 2.0 with full async support (asyncpg) and Alembic migrations.

When to Activate

• Defining ORM models with Mapped / mapped_column
• Writing async queries (select, join, filter, order_by)
• Managing async sessions (AsyncSession, async_sessionmaker)
• Handling relationships and loading strategies (selectin, joined, lazy)
• Running database transactions or bulk operations
• Writing or debugging Alembic migrations
• Converting between ORM models and domain entities

Model Definition (SQLAlchemy 2.0 style)