Release: 1.4.0b1 beta release | Release Date: November 2, 2020

SQLAlchemy 1.4 Documentation

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, one of the following tutorials shoud be consulted:

As SQLAlchemy 1.4 represents a transition from 1.x to 2.0 style, the below sections are currently mixed as far as which style they are using.

Previous: Relationships API Next: ORM Querying Guide