News and Updates

SQLAlchemy 2.0.16 is now available.

Release 2.0.16 includes a variety of bug fixes and use case additions across the ORM, Core, asyncio and PostgreSQL areas, as well as small adjustments to the Core and test suite to pass all tests on Python 3.12.0b1.

Links to the detailed changelog for 2.0.16 is at Changelog.

SQLAlchemy 2.0.16 is available on the Download Page.

SQLAlchemy 2.0.15 is now available.

Release 2.0.15 adds an additional regression fix related to the series of changes for "insertmanyvalues", which uses a new SQL syntax on the PostgreSQL backend, this time repairing support for the generic Uuid datatype for those cases where multiple uuid values would be INSERTed by the ORM while also using RETURNING.

Links to the detailed changelog for 2.0.15 is at Changelog.

SQLAlchemy 2.0.15 is available on the Download Page.

SQLAlchemy 2.0.14 is now available.

Release 2.0.14 includes bugfixes across the ORM, SQL and dialect-specific categories, including one fix against a rare race condition that's been reported as occurring with the "joined eager loading" strategy under unusual circumstances.

Links to the detailed changelog for 2.0.14 is at Changelog.

SQLAlchemy 2.0.14 is available on the Download Page.

SQLAlchemy 2.0.13 is now available.

Release 2.0.13 fixes a series of bugs and some regressions related to recent changes, and also adds a new feature specific to the sqlalchemy.ext.asyncio extension, a utility class AsyncAttrs, which adds a generic attribute access namespace to any mapped class .awaitable_attrs, which returns any attribute as an awaitable, allowing inline access to collections and other attributes that are using lazy loading or other varieties of expired/deferred/etc column loading.

Links to the detailed changelog for 2.0.13 is at Changelog.

SQLAlchemy 2.0.13 is available on the Download Page.

SQLAlchemy 1.4.48 is now available.

Release 1.4.48 includes a critical bugfix in the SQL caching system, backported from version 2.0.12, where SQL expressions that made use of hybrid_property() in conjunction with the ORM aliased() construct would not be appropriately cached, leading to memory issues. All applications that make use of these constructs are strongly encouraged to upgrade to 1.4.48 (the same fix is in the 2.0 series at version 2.0.12).

The complete changelog for 1.4.48 is at Changelog.

SQLAlchemy 1.4.48 is available on the Download Page.