rel_2_0_41
📦 sqlalchemyView on GitHub →
✨ 2 features🐛 6 fixes🔧 6 symbols
Summary
SQLAlchemy 2.0.41 introduces PostgreSQL and Oracle enhancements, fixes several bugs across multiple dialects, and improves Python 3.14 beta compatibility.
✨ New Features
- Added support for the postgresql_include keyword argument to sqlalchemy.schema.UniqueConstraint and sqlalchemy.schema.PrimaryKeyConstraint.
- Introduced new Oracle datatype sqlalchemy.dialects.oracle.VECTOR with methods l2_distance, cosine_distance, inner_product, and added oracle_vector parameter to sqlalchemy.schema.Index and oracle_fetch_approximate parameter to sqlalchemy.sql.select.Select.fetch.
🐛 Bug Fixes
- Adjusted test suite and ORM class‑annotation scanning to work with Python 3.14 beta releases.
- Engine now omits the offending URL from error messages when a URL cannot be parsed.
- Removed the __getattr__() rule from sqlalchemy.__init__ that interfered with type checking.
- Fixed MySQL DEFAULT rendering regression where lowercase "on update" caused incorrect parenthesis insertion.
- Corrected SQLite compiler handling of the localtimestamp function and added test support for related SQL functions.
- Removed the license classifier from setup.cfg to eliminate deprecation warnings during package build.
🔧 Affected Symbols
sqlalchemy.__init__sqlalchemy.schema.UniqueConstraintsqlalchemy.schema.PrimaryKeyConstraintsqlalchemy.dialects.oracle.VECTORsqlalchemy.schema.Indexsqlalchemy.sql.select.Select.fetch