News and Updates

SQLAlchemy release 2.0.5 is now available. The release is numbered as 2.0.5.post1 due to an issue building wheel files.

Release 2.0.5 includes a series of bugfixes across most major components including the ORM, dialects, and various typing-related issues.

Links to the detailed changelog for 2.0.5.post1 is at Changelog.

SQLAlchemy 2.0.5.post1 is available on the Download Page.

SQLAlchemy release 2.0.4 is now available.

Release 2.0.4 delivers some new capabilities to the 2.0 series, including plug-in support for Pydantic dataclasses, improved typing constructs for hybrid attributes, and the ability to control the sorted order of table columns explicitly when using ORM Declarative mappings.

Links to the detailed changelog for 2.0.4 is at Changelog.

SQLAlchemy 2.0.4 is available on the Download Page.

SQLAlchemy release 2.0.3 is now available.

This release fixes a critical regression identified in the SQL expression mechanics, where correct parenthesization would fail to be applied to individual compound elements of a larger compound expression which featured more than two elements joined together by a common operator.

Release 2.0.3 is strongly recommended for all current users of the 2.0 series.

Links to the detailed changelog for 2.0.3 is at Changelog.

SQLAlchemy 2.0.3 is available on the Download Page.

SQLAlchemy release 2.0.2 is now available.

After less than a week, another batch of bug fixes and improvements, mostly involving new Declarative features is ready to download.

One particular issue in this release was an identified issue with the connection pool under asyncio when using the asyncpg database driver; the pool would not gracefully report the condition when a pooled connection was not correctly returned to the pool, which has been fixed.

Links to the detailed changelog for 2.0.2 is at Changelog.

SQLAlchemy 2.0.2 is available on the Download Page.

SQLAlchemy release 2.0.1 is now available.

The release of 2.0 has been very well received, with about half of daily downloads (600K / day) going to the 2.0 series. The ORM Declarative Annotations feature is in particular receiving lots of attention, and the focus of 2.0 is improvements and fixes to this new system, as well as ongoing improvements and fixes to the general pep-484 typing now applied inline within the main source.

The release also repairs one issue within the new "bulk insert" mechanics, fixing compilation for complex INSERT statements with nested CTEs that may themselves also include INSERT statements.

The release has otherwise so far been very smooth with only a few trivial regressions which have been fixed.

Links to the detailed changelog for 2.0.1 is at Changelog.

SQLAlchemy 2.0.1 is available on the Download Page.