SQLAlchemy
The Database Toolkit for Python
The Database Toolkit for Python
  • home
  • features
    • Philosophy Statement
    • Feature Overview
    • Testimonials
  • news
  • documentation
    • Current Documentation (version 2.0)

    • Documentation by Version
    • Version 2.0
    • Version 1.4
    • Version 1.3

    • Talks and Tutorials
    • Published content overview
  • community
    • Get Support
    • Participate
    • Develop
    • Code of Conduct
    • Github
  • download
    • Download
    • Current Release Series (2.0)
    • Maintenance Release (1.4)
    • Development Access
    • License
    • Version Numbering
    • Release Status
Release: 1.3.24 legacy version | Release Date: March 30, 2021

SQLAlchemy 1.3 Documentation

SQLAlchemy 1.3 Documentation

legacy version

Home | Download this Documentation

SQLAlchemy ORM

  • Object Relational Tutorial
  • Mapper Configuration
  • Relationship Configuration
  • Loading Objects¶
    • Loading Columns
    • Relationship Loading Techniques
    • Loading Inheritance Hierarchies
    • Constructors and Object Initialization
    • Query API
  • Using the Session
  • Events and Internals
  • ORM Extensions
  • ORM Examples

Project Versions

  • 1.3.24

Home | Download this Documentation

  • Previous: Relationships API
  • Next: Loading Columns
  • Up: Home
    • SQLAlchemy ORM
  • On this page:
    • Loading Objects

Loading Objects¶

Notes and features regarding the general loading of mapped objects.

For an in-depth introduction to querying with the SQLAlchemy ORM, please see the Object Relational Tutorial.

  • Loading Columns
    • Deferred Column Loading
    • Column Bundles
  • 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
    • Using with_polymorphic
    • Polymorphic Selectin Loading
    • Referring to specific subtypes on relationships
    • Loading objects with joined table inheritance
    • Loading objects with single table inheritance
    • Inheritance Loading API
  • Constructors and Object Initialization
    • reconstructor()
  • Query API
    • The Query Object
    • ORM-Specific Query Constructs
Previous: Relationships API Next: Loading Columns
© Copyright 2007-2021, the SQLAlchemy authors and contributors.

flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.

Created using Sphinx 5.3.0. Documentation last generated: Sun 05 Feb 2023 04:28:22 PM

SQLAlchemy Sponsors

Python

Website content copyright © by SQLAlchemy authors and contributors. SQLAlchemy and its documentation are licensed under the MIT license.

SQLAlchemy is a trademark of Michael Bayer. mike(&)zzzcomputing.com All rights reserved.

Website generation by zeekofile, with huge thanks to the Blogofile project.

Mastodon