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: 2.0.7 current release | Release Date: March 18, 2023

SQLAlchemy 2.0 Documentation

SQLAlchemy 2.0 Documentation

current release

Home | Download this Documentation

SQLAlchemy 2.0 Documentation

  • Overview
  • SQLAlchemy Unified Tutorial
  • SQLAlchemy ORM
  • SQLAlchemy Core¶
    • SQL Statements and Expressions API
    • Schema Definition Language
    • SQL Datatype Objects
    • Engine and Connection Use
    • Core API Basics
  • Dialects
  • Frequently Asked Questions
  • Error Messages
  • Changes and Migration

Project Versions

  • 2.0.7

Home | Download this Documentation

  • Previous: ORM Examples
  • Next: SQL Statements and Expressions API
  • Up: Home
  • On this page:
    • SQLAlchemy Core

SQLAlchemy Core¶

The breadth of SQLAlchemy’s SQL rendering engine, DBAPI integration, transaction integration, and schema description services are documented here. In contrast to the ORM’s domain-centric mode of usage, the SQL Expression Language provides a schema-centric usage paradigm.

  • SQL Statements and Expressions API
    • Column Elements and Expressions
    • Operator Reference
    • SELECT and Related Constructs
    • Insert, Updates, Deletes
    • SQL and Generic Functions
    • Custom SQL Constructs and Compilation Extension
    • Expression Serializer Extension
    • SQL Expression Language Foundational Constructs
    • Visitor and Traversal Utilities
  • Schema Definition Language
    • Describing Databases with MetaData
    • Reflecting Database Objects
    • Column INSERT/UPDATE Defaults
    • Defining Constraints and Indexes
    • Customizing DDL
  • SQL Datatype Objects
    • The Type Hierarchy
    • Custom Types
    • Base Type API
  • Engine and Connection Use
    • Engine Configuration
    • Working with Engines and Connections
    • Connection Pooling
    • Core Events
  • Core API Basics
    • Events
    • Runtime Inspection API
    • Core Exceptions
    • Core Internals
Previous: ORM Examples Next: SQL Statements and Expressions API
© Copyright 2007-2023, 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 19 Mar 2023 06:10:54 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