CTE

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.