News and Updates

SQLAlchemy 1.4.27 is now available.

Release 1.4.27 includes a series of fixes and improvements across the Core and ORM components as well as for individual dialects.

The 1.4 series has moved off of the "main" branch of SQLAlchemy and 2.0 development is now underway.

As is always the case, huge thanks to our user and contributor communities as for their ongoing help and support as well as to our core team for their dedicated efforts and hard work.

The complete changelog for 1.4.27 is at Changelog.

SQLAlchemy 1.4.27 is available on the Download Page.

SQLAlchemy 1.4.26 is now available.

Release 1.4.26 is chock full of a number of bug fixes as the 1.4 release has settled into general use. Key fixes in release 1.4.26 include:

• a repair to the workings of the update() statement in an ORM context when used with hybrid and composite attributes.
• Fixes for the with_loader_criteria() ORM option
• adjustments to the ORM Session interface to accommodate for new API features
• some new legacy warnings for lesser used patterns with Query.join()
• SQL / ORM fixes for the use case of selecting from repeated, non-labeled column expressions, typically the null() construct when used as a placeholder in a UNION statement.
• For PostgreSQL, refinements to the "expanding IN" SQL feature when used with PostgreSQL ARRAY datatypes as well as fixes for the mostly PostgreSQL-specific any_() and all_() column methods.
• For MySQL, repaired support for new behaviors in MariaDB 10.6
• For SQL Server, reflection fixes and improvements for foreign key constraints as well table /view detection.

As is always the case, huge thanks to our user and contributor communities as for their ongoing help and support as well as to our core team for their dedicated efforts and hard work.

The complete changelog for 1.4.26 is at Changelog.

SQLAlchemy 1.4.26 is available on the Download Page.

SQLAlchemy 1.4.25 is now available.

Release 1.4.25 fixes a single platform installation issue where the platform names for aarch64 as well as AMD64 on windows only were excluded from the list of platforms for which the greenlet dependency, necessary for SQLAlchemy asyncio support, is required, preventing greenlet from being installed automatically for these platforms. The greenlet dependency may also be installed manually using the sqlalchemy[asyncio] installation target with pip.

The complete changelog for 1.4.25 is at Changelog.

SQLAlchemy 1.4.25 is available on the Download Page.

SQLAlchemy 1.4.24 is now available.

Notable highlights for 1.4.24 include:

• A new driver for the asyncmy asynchronous database driver is added. This driver is added in response to compatibility issues in the aiomysql project which remain unaddressed.
• ORM loader options can now be used with the Session.merge() and AsyncSession.merge() methods.
• A new method Session.scalars and AsyncSession.scalars is added to provide for retrieving a scalar-based result, typically for ORM objects.

Thanks to our user and contributor communities for their ongoing help and support and our core team for their excellent work.

The complete changelog for 1.4.24 is at Changelog.

SQLAlchemy 1.4.24 is available on the Download Page.

SQLAlchemy 1.4.23 is now available.

Release 1.4.23 has a significant number of fixes and improvements. Notable changes include:

• The greenlet dependency used by the asyncio extension now will install by default only on common platforms where greenlet is known to be supported; if asyncio support is needed on less common architectures, the sqlalchemy[asyncio] target needs to be stated explicitly when installing with pip.
• Support is improved for the sqlalchemy2-stubs package by allowing declaration of "generic" types against SQLAlchemy classes at runtime
• Changes have been made to the "selectinload" and "lazyload" loader strategies to accommodate various loader and user-defined options scenarios more correctly, by implementing a simplification of these strategies to no longer use the "lambda caching" feature internally.
• Added a new parameter maintain_column_froms to the Select.with_only_columns method so that it is easier to change the columns being SELECTed from without altering the FROM list.

Thanks to our user and contributor communities for their ongoing help and support and our core team for their excellent work.

The complete changelog for 1.4.23 is at Changelog.

SQLAlchemy 1.4.23 is available on the Download Page.