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.7 is now available.

Release 2.0.7 includes a critical bugfix in the SQL caching system, 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 2.0.7 (or SQLAlchemy 1.4.47, which also includes the same fix).

Links to the detailed changelog for 2.0.7 is at Changelog.

SQLAlchemy 2.0.7 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.