sqlalchemy-orm

Python SQL toolkit and ORM with modern query builder, relationship mapping, and async support. SQLAlchemy 2.0 introduced modern patterns with better type hints, improved query syntax, and async support. Key Changes from 1.x: One-to-Many: Many-to-Many: When using Sqlalchemy, these skills enhance your workflow: [Full documentation available in these skills if deployed in your bundle] - Supports SQLAlchemy 2.0 modern API with type hints, select() queries, and Mapped[T] declarative models; includes async support via AsyncSession and AsyncSessionLocal - Covers one-to-many and many-to-many relationships with eager loading patterns ( selectinload , joinedload ) to prevent N+1 query problems - Integrates with FastAPI via dependency injection, Alembic for schema migrations, and connection pooling with configurable pool size and recycling - Includes CRUD operations, transaction management, batch operations, and testing patterns with pytest and in-memory SQLite - select() instead of Query - Mapped[T] and mapped_column() for type hints - Explicit Session.execute() for queries - Better async support with AsyncSession - Use SQLAlchemy 2.0 Syntax : Modern API with better type hints - Type Annotations : Use Mapped[T] and mapped_column() - Eager Loading : Solve N+1 queries with selectinload / joinedload - Session Management : Use dependency injection pattern - Migrations : Always use Alembic...