SQLAlchemy ORM

Here, the Object Relational Mapper is introduced and fully described. If you want to work with higher-level SQL which is constructed automatically for you, as well as automated persistence of Python objects, proceed first to the tutorial.

• ORM Quick Start
  • Declare Models
  • Create an Engine
  • Emit CREATE TABLE DDL
  • Create Objects and Persist
  • Simple SELECT
  • SELECT with JOIN
  • Make Changes
  • Some Deletes
  • Learn the above concepts in depth
• ORM Mapped Class Configuration
  • ORM Mapped Class Overview
  • Mapping Classes with Declarative
  • Integration with dataclasses and attrs
  • SQL Expressions as Mapped Attributes
  • Changing Attribute Behavior
  • Composite Column Types
  • Mapping Class Inheritance Hierarchies
  • Non-Traditional Mappings
  • Configuring a Version Counter
  • Class Mapping API
• Relationship Configuration
  • Basic Relationship Patterns
  • Adjacency List Relationships
  • Configuring how Relationship Joins
  • Working with Large Collections
  • Collection Customization and API Details
  • Special Relationship Persistence Patterns
  • Using the legacy ‘backref’ relationship parameter
  • Relationships API
• ORM Querying Guide
  • Writing SELECT statements for ORM Mapped Classes
  • Writing SELECT statements for Inheritance Mappings
  • ORM-Enabled INSERT, UPDATE, and DELETE statements
  • Column Loading Options
  • Relationship Loading Techniques
  • ORM API Features for Querying
  • Legacy Query API
• Using the Session
  • Session Basics
  • State Management
  • Cascades
  • Transactions and Connection Management
  • Additional Persistence Techniques
  • Contextual/Thread-local Sessions
  • Tracking queries, object and Session Changes with Events
  • Session API
• Events and Internals
  • ORM Events
  • ORM Internals
  • ORM Exceptions
• ORM Extensions
  • Asynchronous I/O (asyncio)
  • Association Proxy
  • Automap
  • Baked Queries
  • Declarative Extensions
  • Mypy / Pep-484 Support for ORM Mappings
  • Mutation Tracking
  • Ordering List
  • Horizontal Sharding
  • Hybrid Attributes
  • Indexable
  • Alternate Class Instrumentation
• ORM Examples
  • Mapping Recipes
  • Inheritance Mapping Recipes
  • Special APIs
  • Extending the ORM