Understanding SQLAlchemy 2.0 Patterns

SQLAlchemy 2.0 introduced a new query interface that's more explicit and Pythonic. The shift from Model.query to db.session.execute(db.select(Model)) provides better type safety and more predictable behavior. We'll walk through common patterns: filtering, joining, eager loading, and pagination.