sqlalchemy-orm

SQLAlchemy declarative models use the Mapped and mapped_column constructs to define type-safe database schemas in Python. This approach provides clear type hinting for columns while reducing boilerplate code compared to writing raw SQL definitions.

SQLAlchemy async session setup requires configuring an AsyncSession alongside an async engine for FastAPI integration. This enables asynchronous database interactions and efficient querying within modern Python web frameworks without blocking the event loop.

To avoid N+1 queries in SQLAlchemy ORM, apply eager loading strategies to your relationships. This fetches related objects in a single query or joined statement, preventing the performance bottleneck of issuing separate queries for each related item.

Yes, this Skill supports Alembic-based schema migrations for FastAPI, Flask, and Django projects. It provides tooling guidance and integration patterns to manage database schema evolution directly within these Python web frameworks.

SQLAlchemy ORM configures one-to-many and many-to-many relationships using back_populates and association tables. This mechanism explicitly links related models, ensuring bidirectional access and consistent state across joined database records.

SQLAlchemy 2.0 models complex databases and enables expressive querying in Python, reducing error-prone boilerplate SQL. It provides modern type-hinted declarative models, relationship management, and session handling to streamline data access layers.