Release: 2.0.0b1
in development
| Release Date: not released yet
SQLAlchemy 2.0 Documentation
SQLAlchemy ORM
- ORM Quick Start
- Mapper Configuration
- Relationship Configuration
- Querying Data, Loading Objects¶
- Using the Session
- Events and Internals
- ORM Extensions
- ORM Examples
Project Versions
- Previous: Relationships API
- Next: ORM Querying Guide
- Up: Home
- On this page:
Querying Data, Loading Objects¶
The following sections refer to techniques for emitting SELECT statements within an ORM context. This involves primarily statements that return instances of ORM mapped objects, but also involves calling forms that deliver individual column or groups of columns as well.
For an introduction to querying with the SQLAlchemy ORM, start with the SQLAlchemy 2.0 Tutorial.
- ORM Querying Guide
- Loading Columns
- Relationship Loading Techniques
- Configuring Loader Strategies at Mapping Time
- Relationship Loading with Loader Options
- Lazy Loading
- Joined Eager Loading
- Subquery Eager Loading
- Select IN loading
- What Kind of Loading to Use ?
- Polymorphic Eager Loading
- Wildcard Loading Strategies
- Routing Explicit Joins/Statements into Eagerly Loaded Collections
- Creating Custom Load Rules
- Relationship Loader API
- Loading Inheritance Hierarchies
- Constructors and Object Initialization
- Legacy Query API
Previous:
Relationships API
Next:
ORM Querying Guide
© Copyright 2007-2022, the SQLAlchemy authors and contributors.
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 4.5.0.