SQLAlchemy - The Database Toolkit for Python
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence …
SQLAlchemy Documentation — SQLAlchemy 2.0 Documentation
Dec 9, 2025 · New users of SQLAlchemy, as well as veterans of older SQLAlchemy release series, should start with the SQLAlchemy Unified Tutorial, which covers everything an Alchemist needs to …
Features - SQLAlchemy
Any hyper-optimized query that you or your DBA can cook up, you can run in SQLAlchemy, and as long as it returns the expected columns within a rowset, you can get your objects from it.
Library - SQLAlchemy
A detailed walkthrough of SQLAlchemy's Session, describing the rationale for its existence, its driving philosophies, and finally a walkthrough of Session lifecycle through the use of an animated diagram.
Download - SQLAlchemy
Updates for critical fixes will be made available as needed, but applications which continue to be under active development are advised to begin upgrading to the current series of SQLAlchemy (currently …
Object Relational Tutorial (1.x API) - SQLAlchemy
The SQLAlchemy Object Relational Mapper presents a method of associating user-defined Python classes with database tables, and instances of those classes (objects) with rows in their …
Query API — SQLAlchemy 1.4 Documentation
class sqlalchemy.orm.Query(entities, session=None) ¶ ORM-level SQL construction object. Query is the source of all SELECT statements generated by the ORM, both those formulated by end-user query …
Philosophy - SQLAlchemy
The main goal of SQLAlchemy is to change the way you think about databases and SQL! Read some key features of SQLAlchemy, as well as what people are saying about SQLAlchemy.
Overview — SQLAlchemy 2.1 Documentation
The SQLAlchemy SQL Toolkit and Object Relational Mapper is a comprehensive set of tools for working with databases and Python. It has several distinct areas of functionality which can be used …
SQLAlchemy Unified Tutorial — SQLAlchemy 2.1 Documentation
SQLAlchemy Core is the foundational architecture for SQLAlchemy as a “database toolkit”. The library provides tools for managing connectivity to a database, interacting with database queries and …