2.0.41

Released: May 14, 2025

platform

• [platform] [bug] Adjusted the test suite as well as the ORM's method of scanning classes for annotations to work under current beta releases of Python 3.14 (currently 3.14.0b1) as part of an ongoing effort to support the production release of this Python release. Further changes to Python's means of working with annotations is expected in subsequent beta releases for which SQLAlchemy's test suite will need further adjustments.

  References: #12405

engine

• [engine] [bug] The error message that is emitted when a URL cannot be parsed no longer includes the URL itself within the error message.

  References: #12579

typing

• [typing] [bug] Removed __getattr__() rule from sqlalchemy/__init__.py that appeared to be trying to correct for a previous typographical error in the imports. This rule interferes with type checking and is removed.

  References: #12588

postgresql

• [postgresql] [usecase] Added support for postgresql_include keyword argument to _schema.UniqueConstraint and _schema.PrimaryKeyConstraint. Pull request courtesy Denis Laxalde.

  References: #10665

mysql

• [mysql] [bug] Fixed regression caused by the DEFAULT rendering changes in version 2.0.40 via #12425 where using lowercase on update in a MySQL server default would incorrectly apply parenthesis, leading to errors when MySQL interpreted the rendered DDL. Pull request courtesy Alexander Ruehe.

  References: #12488

sqlite

• [sqlite] [bug] Fixed and added test support for some SQLite SQL functions hardcoded into the compiler, most notably the localtimestamp function which rendered with incorrect internal quoting.

  References: #12566

oracle

• [oracle] [usecase] Added new datatype _oracle.VECTOR and accompanying DDL and DQL support to fully support this type for Oracle Database. This change includes the base _oracle.VECTOR type that adds new type-specific methods l2_distance, cosine_distance, inner_product as well as new parameters oracle_vector for the Index construct, allowing vector indexes to be configured, and oracle_fetch_approximate for the Select.fetch() clause. Pull request courtesy Suraj Shaw.

  References: #12317, #12341

misc

• [bug] [installation] Removed the "license classifier" from setup.cfg for SQLAlchemy 2.0, which eliminates loud deprecation warnings when building the package. SQLAlchemy 2.1 will use a full PEP 639 configuration in pyproject.toml while SQLAlchemy 2.0 remains using setup.cfg for setup.