News and Updates

SQLAlchemy release 1.1.1 is now available.

Release 1.1.1 includes two quick hits to issues reported in 1.1.0, released two days ago. One is a failure to connect to some configurations of SQL Server with pyodbc, and the other is that a newly added CompileError that intercepts primary key issues on INSERT has been dialed back to a warning, allowing the database to raise IntegrityError as it normally would.

Changelog for 1.1.1 is at Changelog.

SQLAlchemy 1.1.1 is available on the Download Page.

SQLAlchemy release 1.1.0 is now available.

Release 1.1.0 is the first official release in the 1.1 series, after three beta releases. The release represents the past eighteen months of new feature development since version 1.0 was released. The very long list of new capabilities has a focus on Core, particularly in the area of SQL syntaxes that are either solely supported by, or are most commonly used on the Postgresql database, and development was greatly assisted by a highly involved community working sometimes for many weeks on new features.

Major new SQL features include:

• Common table expression (CTE) support for INSERT, UPDATE, DELETE
• Support for Postgresql upsert - INSERT..ON CONFLICT (DO UPDATE | DO NOTHING)
• Support for MySQL's JSON type
• Support for RANGE and ROWS specification within window functions
• Support for the SQL LATERAL keyword support by Postgresql
• Support for TABLESAMPLE
• Core and ORM support for FULL OUTER JOIN
• Support for IS DISTINCT FROM and IS NOT DISTINCT FROM
• Support for WITHIN GROUP, ARRAY_AGG
• Support for FOR UPDATE SKIP LOCKED / FOR NO KEY UPDATE / FOR KEY SHARE

There are also many new ORM features including a new "raise" loader that prevents inadvertent lazy loading, new event hooks for Session objects that allow tracking of all stages of an object's lifecycle, and new "mutable" collections for columns that store serialized object structures.

Along with the new SQL syntax and ORM features are a wide array of ORM and execution engine fixes and improvements, and an absolute minimum of behavioral changes that run the risk of being surprising. Nevertheless, as is always the case, there are many areas where something that didn't work before will work now; users should please carefully review the full series of migration notes at What's new in 1.1? to see the full expanse of things that have changed.

The complete changelog for 1.1.0 as well as all the beta releases is at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.1.0 is available on the Download Page.

SQLAlchemy release 1.0.15 is now available.

Release 1.0.15 features a small number of bug fixes that have been made over the past two months since the previous 1.0.x release.

Users should review the changelog for 1.0.15 at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.15 is available on the Download Page.

SQLAlchemy release 1.1.0b3 is now available.

This is likely the last beta of the 1.1 series, which repairs a few issues in the new CTE for UPDATE/INSERT feature. Overall not many regressions or issues have been reported in the beta series, however this is typical; once the 1.1 final release comes out, the userbase grows dramatically and more issues should be expected.

Users should carefully review the What's New in SQLAlchemy 1.1? document as well as the Changelog to note which behaviors and issues are affected. We'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.1.0b3 is available on the Download Page.

SQLAlchemy release 1.0.14 is now available.

This is the latest release in the 1.0 series which includes a variety of bug fixes that have accumulated since the last 1.0 release. This release happens to only feature Core and dialect level changes; none are ORM specific. All applicable fixes here are also in the 1.1 series, most of which are already released as of 1.1.0b2. As the 1.1 series moves towards final release, the 1.0 series will move into "maintenance" mode with very few additional changes being made.

Users should review the changelog for 1.0.14 at Changelog; we'd like to thank the many contributors who helped with this release.

SQLAlchemy 1.0.14 is available on the Download Page.