SQLAlchemy 2.1.0 正式发布

SQLAlchemy 2.1.0 生产版本已于2026年9月24日正式发布，这是SQLAlchemy 2.1系列的首个生产版本。1该版本带来了多项重大调整，包括移除默认greenlet依赖、更换数据库默认驱动以及提升Python最低版本要求。1

本次更新中，greenlet不再作为默认依赖自动安装，用户如需异步功能需通过执行pip install sqlalchemy[asyncio]单独安装。1数据库驱动方面，PostgreSQL的默认驱动改为psycopg（psycopg3），Oracle默认驱动改为oracledb。1与此同时，项目将Python最低支持版本提升至3.11，而Python 3.10将在一周多后进入生命周期结束。1

SQLAlchemy 2.1.0还新增了多项功能特性，包括T-Strings、CREATE VIEW和CREATE TABLE AS支持，以及Microsoft SQL Server驱动支持。1这次发布距离上一主版本2.0的发布已经过去三年。1

SQLAlchemy 2.1.0, the first production release in the 2.1 series, has been launched on September 24, 2026 1. This version introduces significant changes to the ORM framework, coming three years after the release of version 2.0 1.

The release modifies several core dependencies and system requirements 1. Greenlet support is no longer installed by default; users requiring asyncio functionality must explicitly install it via pip install sqlalchemy[asyncio] 1. The default PostgreSQL driver has been switched to psycopg (psycopg3), while Oracle now defaults to oracledb 1. Additionally, the minimum Python version requirement has been raised to 3.11, ahead of Python 3.10's end-of-life 1.

Among the new features added in this release are T-Strings, support for CREATE VIEW and CREATE TABLE AS statements, and a Microsoft SQL Server Driver implementation 1.