sqlalchemy▌

<essential_principles>

Simple, pragmatic, opinionated. Only what matters for writing production-grade SQLAlchemy and Alembic code.

Python SQL toolkit and ORM with modern query builder, relationship mapping, and async support. \n \n Supports SQLAlchemy 2.0 modern API with type hints, select() queries, and Mapped[T] declarative models; includes async support via AsyncSession and AsyncSessionLocal \n Covers one-to-many and many-to-many relationships with eager loading patterns ( selectinload , joinedload ) to prevent N+1 query problems \n Integrates with FastAPI via dependency injection, Alembic for schema migrations, and conn