News and Updates

SQLAlchemy release 2.0.8 is now available.

Release 2.0.8 includes a wide variety of bugfixes across the Core and ORM components. The majority of ORM fixes involve new Declarative features including Annotated Declarative as well as Declarative Dataclass Mappings.

Within Core, important fixes include a critical data-oriented fix for the PostgreSQL dialects involving LIKE expressions for fixed-length string datatypes, which was a regression in the 2.0 series.

Links to the detailed changelog for 2.0.8 is at Changelog.

SQLAlchemy 2.0.8 is available on the Download Page.

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.