News and Updates

SQLAlchemy 2.0.29 Released
permalink

SQLAlchemy 2.0.29 is now available.

Release 2.0.29 includes an adjustment to a behavior introdcued in 2.0.10 regarding the robustness of the new "insertmanyvalues" bulk insert feature. This adjustment allows third party libraries that define their own primary-key oriented datatypes, like GUID types, to work in this mode without requiring special adjustments. Also included are some ORM Annotated Declarative fixes, pep-484 typing fixes and test suite improvements, among other things.

Links to the detailed changelog for 2.0.29 is at Changelog.

SQLAlchemy 2.0.29 is available on the Download Page.

SQLAlchemy 1.4.52 Released
permalink

SQLAlchemy 1.4.52 is now available.

This release was made to support a single ORM issue backport from the 2.0 series, involving a shortcoming in the with_loader_criteria() ORM option that is frequently used to limit results based on ACLs and similar criteria.

The complete changelog for 1.4.52 is at Changelog.

SQLAlchemy 1.4.52 is available on the Download Page.

SQLAlchemy 2.0.28 Released
permalink

SQLAlchemy 2.0.28 is now available.

Release 2.0.28 includes two ORM related regression fixes, one of which is a performance regression regarding ORM "criteria" options such as the with_expression() construct as well as when adding WHERE criteria to loader options such as selectinload(). The replacement approach is significantly simpler and may have a noticeable effect for applications which encounter this specific codepath / scenario.

Links to the detailed changelog for 2.0.28 is at Changelog.

SQLAlchemy 2.0.28 is available on the Download Page.

SQLAlchemy 2.0.27 Released
permalink

SQLAlchemy 2.0.27 is now available.

Release 2.0.27 fixes a single regression caused by a fix for the asyncpg dialect, where an exception catch was catching an object reference that wasn't present.

Links to the detailed changelog for 2.0.27 is at Changelog.

SQLAlchemy 2.0.27 is available on the Download Page.

SQLAlchemy 2.0.26 Released
permalink

SQLAlchemy 2.0.26 is now available.

Release 2.0.26 has a wide array of bugfixes across almost all the dialects, the ORM, Core components, as well as typing and example fixes.

Links to the detailed changelog for 2.0.26 is at Changelog.

SQLAlchemy 2.0.26 is available on the Download Page.