News and Updates

SQLAlchemy 1.4.7 is now available.

Release 1.4.7 includes two ORM related fixes relating to the "autobegin" feature of the Session as well as some new eager loading features, and is recommended for all users of the ORM.

While the releases are coming fast as we get 1.4 fully adapted to an ever growing expanse of existing SQLAlchemy codebases, every release still relies on our great userbase and core dev team to report, triage and fix as fast as possible; thanks to everyone involved.

The complete changelog for 1.4.7 is at Changelog.

SQLAlchemy 1.4.7 is available on the Download Page.

SQLAlchemy 1.4.6 is now available.

Continuing with the fastest series of SQLAlchemy releases ever, 1.4.6 has a handful of fixes, two of which are further small but potentially impactful regressions from the 1.3 series.

Release 1.4.6 has additional fixes for LIMIT/OFFSET queries on Oracle and SQL Server as well as a fix to the methodology of the "yield_per" feature when used with the legacy ORM Query object.

Also included are significant improvements to the stability of the Mypy plugin.

Huge thanks to our userbase and core development team for working to make release 1.4.6 possible.

The complete changelog for 1.4.6 is at Changelog.

SQLAlchemy 1.4.6 is available on the Download Page.

SQLAlchemy 1.4.5 is now available.

Release 1.4.5 includes the next round of mostly small regressions and bug fixes for the 1.4 series. The most major change in this release is that the "statement caching" feature has been changed to be "opt in" for third party dialects, after the identification of some patterns in some dialects that are not compatible with statement caching. Third party dialects that want to add support for statement caching should set the supports_statement_cache flag on each dialect subclass that they implement, and then test that SQL statements which include literal Python values, particularly those used for LIMIT/OFFSET, are rendered correctly as they change across executions for the same statement. See the changelog for further details.

The above issue was also identified in the Oracle dialect, so all Oracle installations using the 1.4 series should upgrade to 1.4.5.

Support for the Mypy plugin is still ongoing; while there are some Mypy fixes in this release, there are still additional known issues which will be resolved in upcoming releases. The sqlalchemy2-stubs package is also undergoing rapid development and should be improving significantly in the coming weeks.

Huge thanks to our userbase and core development team for working to make release 1.4.5 possible.

The complete changelog for 1.4.5 is at Changelog.

SQLAlchemy 1.4.5 is available on the Download Page.

SQLAlchemy 1.4.4 is now available.

Release 1.4.4 includes a short set of mostly minor bug fixes, and a small fix for one significant issue in the new PropComparator.and_() method which can be used to apply custom criteria to relationship loads where bound parameters would not be applied correctly.

The primary development effort within the 1.4 series is further fixes and improvements to the Mypy plugin as well as the related sqlalchemy2-stubs package. Upcoming fixes to those features involve more significant development of new test suites so are not included in 1.4.4 as of yet. Mypy plugin work continues to go well as some difficult issues integrating with Mypy have been figured out.

Huge thanks to our userbase and core development team for working to make release 1.4.4 possible.

For users migrating from 1.3, the first stop is the What's New in 1.4? document which will provide an overview of how to get started with SQLAlchemy 1.4.

The complete changelog for 1.4.4 as well as all the beta releases is at Changelog.

SQLAlchemy 1.4.4 is available on the Download Page.

SQLAlchemy release 1.3.24 is now available.

Release 1.3.24 provides a series of bugfixes for the 1.3 series of SQLAlchemy, which are all effectively backports from the 1.4 series, now in production releases.

As is the case with all releases, we'd like to thank all the contributors who helped with this release.

Changelog for 1.3.24 is at Changelog.

SQLAlchemy 1.3.24 is available on the Download Page.