SQLAlchemy Deep Dive

Advanced

When basic CRUD isn't enough. Hybrid properties, event hooks, eager loading, and query profiling.

0/7

Foundations

Hybrid Properties@hybrid_property

Medium15m

Event Listeners (before_insert)event.listen()

Medium12m

Raw SQL with text()session.execute(text())

Medium10m

Eager vs Lazy Loadingjoinedload / selectinload

Medium15m

Core

Polymorphic Models__mapper_args__

Hard20m

Multi-tenancy PatternsSchema-per-tenant

Hard25m

Query Profiling & EXPLAINecho=True + EXPLAIN

Medium12m