1.4.53

Released: July 29, 2024

general

• [general] [bug] Set up full Python 3.13 support to the extent currently possible, repairing issues within internal language helpers as well as the serializer extension module.

  For version 1.4, this also modernizes the "extras" names in setup.cfg to use dashes and not underscores for two-word names. Underscore names are still present to accommodate potential compatibility issues.

  References: #11417

orm

• [orm] [bug] [regression] Fixed regression going back to 1.4 where accessing a collection using the "dynamic" strategy on a transient object and attempting to query would raise an internal error rather than the expected NoResultFound that occurred in 1.3.

  References: #11562

engine

• [engine] [usecase] Modified the internal representation used for adapting asyncio calls to greenlets to allow for duck-typed compatibility with third party libraries that implement SQLAlchemy's "greenlet-to-asyncio" pattern directly. Running code within a greenlet that features the attribute __sqlalchemy_greenlet_provider__ = True will allow calls to sqlalchemy.util.await_only() directly.

• [engine] [bug] Adjustments to the C extensions, which are specific to the SQLAlchemy 1.x series, to work under Python 3.13. Pull request courtesy Ben Beasley.

  References: #11499

sql

• [sql] [bug] Fixed caching issue where using the TextualSelect.add_cte() method of the TextualSelect construct would not set a correct cache key which distinguished between different CTE expressions.

  References: #11471

• [sql] [bug] Fixed caching issue where the _sql.Select.with_for_update.key_share element of _sql.Select.with_for_update() was not considered as part of the cache key, leading to incorrect caching if different variations of this parameter were used with an otherwise identical statement.

  References: #11544

mypy

• [mypy] [bug] The deprecated mypy plugin is no longer fully functional with the latest series of mypy 1.11.0, as changes in the mypy interpreter are no longer compatible with the approach used by the plugin. If code is dependent on the mypy plugin with sqlalchemy2-stubs, it's recommended to pin mypy to be below the 1.11.0 series. Seek upgrading to the 2.0 series of SQLAlchemy and migrating to the modern type annotations.

sqlite

• [sqlite] [bug] [reflection] Fixed reflection of computed column in SQLite to properly account for complex expressions.

  References: #11582

mssql

• [mssql] [bug] Fixed issue where SQL Server drivers don't support bound parameters when rendering the "frame specification" for a window function, e.g. "ROWS BETWEEN", etc.

  References: #11514