Working with Database Metadata — SQLAlchemy 2.0 Documentation
With engines and SQL execution down, we are ready to begin some Alchemy. The central element of both SQLAlchemy Core and ORM is the SQL Expression Language which allows for fluent, composable construction of SQL queries. The foundation for these queries are Python objects that represent database concepts like tables and columns. These objects are known collectively as database metadata. The most common foundational objects for database metadata in SQLAlchemy are known as MetaData, Table, and Column. The sections below will illustrate how these objects are used in both a Core-oriented style as well as an ORM-oriented style. ORM readers, stay with us! As with other sections, Core users can skip the ORM sections, but ORM users would best be familiar with these objects from both perspectives. The Table object discussed here is declared in a more indirect (and also fully Python-typed) way when using the ORM, however there is still a Table object within the ORM’s configuration. When we work
Working with Database Metadata - SQLAlchemy 2.0 Documentation via SQLAlchemy adapter --> Release: 2.0.51 current release | Release Date: June 15, 2026 SQLAlchemy 2.0 Documentation SQLAlchemy 2.0 Documentation current release Home | Download this Documentation Search terms: SQLAlchemy Unified Tutorial Establishing Connectivity - the Engine Working with Transactions and the DBAPI Working with Database Metadata ¶ Setting up MetaData with Table objects Components of Table Declaring Simple Constraints Emitting DDL to the Database Using ORM Declarative Forms to Define Table Metadata Establishing a D
Explore this link on the map →related reading
- Describing Databases with MetaData - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
- Mediumpython.plainenglish.io
- SQLAlchemy - Quick Guidetutorialspoint.com
- Object Relational Tutorial - SQLAlchemy 1.3 Documentationdocs.sqlalchemy.org
- Reflecting Database Objects - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
- Glossary - SQLAlchemy 1.4 Documentationdocs.sqlalchemy.org
- Against SQLscattered-thoughts.net
- Types of Mappings - SQLAlchemy 1.3 Documentationdocs.sqlalchemy.org
- The Type Hierarchy - SQLAlchemy 1.4 Documentationdocs.sqlalchemy.org
- Using SELECT Statements - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
- Working with Transactions and the DBAPI - SQLAlchemy 2.0 Documentationdocs.sqlalchemy.org
- SQL style guide by Simon Holywellsqlstyle.guide