SQLAlchemy

SQLAlchemy 2.0.45 introduces PostgreSQL collation reflection and MySQL FOR SHARE support, while fixing numerous bugs across ORM, SQL, typing, and SQLite reflection.

SQLAlchemy 2.0.44 introduces refined ORM type‑alias handling, adds the `_orm.mapped_as_dataclass()` decorator, and fixes numerous bugs across platforms, engines, and dialects.

SQLAlchemy 2.0.43 introduces a new `skip_autocommit_rollback` engine option and adds sparse vector support to Oracle, while fixing several ORM and PostgreSQL bugs.

SQLAlchemy 2.0.42 adds dataclass metadata support, new loader options for composites, enhanced execution‑parameter validation, a VALUES‑CTE helper, PostgreSQL 14+ JSONB subscripting, and numerous bug fixes across ORM, SQL compilation, and dialects.

SQLAlchemy 2.0.41 introduces PostgreSQL and Oracle enhancements, fixes several bugs across multiple dialects, and improves Python 3.14 beta compatibility.

SQLAlchemy 2.0.40 adds GROUPS frame support for window functions, enhances PostgreSQL foreign‑key ON DELETE actions and ARRAY literals, and includes numerous bug fixes across ORM, SQL compilation, asyncio, and MySQL/SQLite dialects.

SQLAlchemy 2.0.39 introduces generic typing for compound selects and new constraint isolation parameters, while fixing numerous ORM, asyncio, PostgreSQL, and SQLite bugs.

SQLAlchemy 2.0.38 introduces a new asyncio.shield() safeguard for asyncpg termination, fixes several bugs across engines and dialects, and changes the default aiosqlite pool, which may require a migration step.