SQLAlchemy
The Database Toolkit for Python
The Database Toolkit for Python
  • home
  • features
    • Feature Overview
    • Testimonials
  • blog
  • library
    • Library
    • Reference

    • Version 2.0 (development)
    • Version 1.4
    • Version 1.3
    • Version 1.2

    • Architecture
    • Citing SQLAlchemy
    • Blog Posts
    • Talks and Tutorials
    • Recipes
  • community
    • Get Support
    • Participate
    • Develop
    • Code of Conduct
    • Github
  • download
    • Download
    • Current Release Series (1.4)
    • Maintenance Release (1.3)
    • Development Access
    • License
    • Version Numbering
    • Release Status
Release: 1.4.39 current release | Release Date: June 24, 2022

SQLAlchemy 1.4 Documentation

SQLAlchemy 1.4 Documentation

current release

Home | Download this Documentation

SQLAlchemy 1.4 Documentation

  • Overview
  • SQLAlchemy 1.4 / 2.0 Tutorial
  • SQLAlchemy ORM
  • SQLAlchemy Core¶
    • SQL Expression Language Tutorial (1.x API)
    • SQL Statements and Expressions API
    • Schema Definition Language
    • Column and Data Types
    • Engine and Connection Use
    • Core API Basics
    • SQLAlchemy 2.0 Future (Core)
  • Dialects
  • Frequently Asked Questions
  • Error Messages
  • Changes and Migration

Project Versions

  • 1.4.39

Home | Download this Documentation

  • Previous: ORM Examples
  • Next: SQL Expression Language Tutorial (1.x 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 Expression Language Tutorial (1.x API)
    • Version Check
    • Connecting
    • Define and Create Tables
    • Insert Expressions
    • Executing
    • Executing Multiple Statements
    • Selecting
    • Selecting Specific Columns
    • Operators
    • Conjunctions
    • Using Textual SQL
    • Using Aliases and Subqueries
    • Using Joins
    • Common Table Expressions (CTE)
    • Everything Else
    • Inserts, Updates and Deletes
    • Further Reference
  • SQL Statements and Expressions API
    • SQL Expression Language Foundational Constructs
    • Column Elements and Expressions
    • Operator Reference
    • Selectables, Tables, FROM objects
    • Insert, Updates, Deletes
    • SQL and Generic Functions
    • Custom SQL Constructs and Compilation Extension
    • Expression Serializer Extension
    • Visitor and Traversal Utilities
  • Schema Definition Language
    • Describing Databases with MetaData
    • Reflecting Database Objects
    • Column INSERT/UPDATE Defaults
    • Defining Constraints and Indexes
    • Customizing DDL
  • Column and Data Types
    • Column and Data Types
    • 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
  • SQLAlchemy 2.0 Future (Core)
Previous: ORM Examples Next: SQL Expression Language Tutorial (1.x API)
© 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 5.0.2.

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.