SQLAlchemy

Complete reference for Python SQL toolkit and ORM.

Overview

SQLAlchemy provides a full suite of well-known enterprise-level persistence patterns, designed for efficient and high-performing database access.

Key Features:

• Core: SQL expression language for building queries
• ORM: Object-relational mapping with declarative models
• Async: Full async/await support (SQLAlchemy 2.0+)
• Migrations: Alembic integration for schema changes
• Multiple DBs: PostgreSQL, MySQL, SQLite, Oracle, SQL Server

Installation

pip install sqlalchemy