Cheatsheets for SQLAlchemy 2.0 (DB-agnostic). Pair with the textbook . For Postgres-specific, see the Postgres cheatsheets .
Cheatsheet: create_engine / create_async_engine, pool params, pre-ping, recycle, events, lifespan integration.
Cheatsheet: DeclarativeBase, Mapped/mapped_column, type mappings, server_default, indexes, unique/check/FK, naming conventions.
Cheatsheet: AsyncSession / Session, add/flush/commit/rollback, expire_on_commit, identity map, merge, scoped patterns.
Cheatsheet: select() / where / order_by / limit / offset / joins / aggregates / subqueries / CTEs / window funcs.
Cheatsheet: relationship(), back_populates, secondary, cascade, joinedload / selectinload / subqueryload, lazy options.
Cheatsheet: session.begin, begin_nested, isolation levels, with_for_update, optimistic locking, deadlock retry.
Cheatsheet: AsyncEngine, AsyncSession, lazy loading caveats, streaming results, run_sync escape hatch.
Cheatsheet: detect N+1, bulk insert/update, yield_per, load_only, defer, EXPLAIN, slow query logging.
Cheatsheet: Alembic setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, common ops.
Cheatsheet: PgBouncer, read replica routing, OTEL instrumentation, multi-tenancy (RLS), DR / failover.