News and Updates

SQLAlchemy 1.4.47 is now available.

Release 1.4.47 includes a critical bugfix in the SQL caching system, backported from version 2.0.7, where SQL expressions that made use of the op() custom operator construct would not be appropriately cached; all applications that make use of the .op() construct are strongly encouraged to upgrade to 1.4.47 (the same fix is in the 2.0 series at version 2.0.7).

Release 1.4.47 also includes a series of other fixes and backports from the 2.0 release series.

The complete changelog for 1.4.47 is at Changelog.

SQLAlchemy 1.4.47 is available on the Download Page.

SQLAlchemy release 2.0.6 is now available.

Release 2.0.6 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.6 is at Changelog.

SQLAlchemy 2.0.6 is available on the Download Page.

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.