SQLAlchemy 2.0.46 is now available.

Release 2.0.46 includes typing improvements for ORM mapped classes and aliasedentities in result row mappings, several PostgreSQL dialect fixes includingcorrections to JSONB operators and improved unicode support in foreign keyreflection, and enhancements to the MariaDB, SQLite, and MSSQL dialects.

Links to the detailed changelog for 2.0.46 is atChangelog.

SQLAlchemy 2.0.46 is available on theDownload Page.

The first beta release of theSQLAlchemy 2.1 series is now available.

Nearly two years in development, the 2.1 series builds upon the new Pythontyping-oriented architecture of SQLAlchemy 2.0, introducing a range ofenhancements and new capabilities across both Core and ORM components, with anemphasis on newer Python idioms such as dataclasses, improved pep-484 typing,template strings, and continued accommodations for Python free threading.

Key improvements in SQLAlchemy 2.1 include:

• Python 3.14 Template String Support - A newtstring() constructworks similarly to thetext() construct, but works with the newt'' syntax added in Python 3.14+, allowing for automatic generationof bound parameters from a fully inline SQL string expression.
• CREATE VIEW and CREATE TABLE AS Support - New DDL constructs enablecreation of views and table-as-select operations
• pep-646 typing for SQL SELECT statements, result sets, rows - TheTuple[]seen in type annotations for selectable statements and results has beenreplaced by the use of pep-646Unpack directly, representing heterogeneousrows and supporting constructs directly without the need to manuallyunpack results from a tuple for typing of individual unpacked values to work.
• Refined Dataclass Mapping - ORM mapped dataclasses no longer populateimplicit defaults in__dict__, resolving workflow issues where foreignkey values would incorrectly override relationship attributes
• Default driver updates for PostgreSQL, Oracle - The default driver forpostgresql:// URLs is nowpsycopg, replacingpsycopg2, and thedefault driver fororacle:// URLs is noworacledb, replacingcx_oracle. This is the first release in SQLAlchemy's history to revisethese default drivers.
• Support for monotonic server side functions such as PostgreSQL's uuidv7()in batched INSERTs - SQLAlchemy's "insertmanyvalues" feature introducedin version 2.0 allowed dramatic improvements for INSERT statements as usedby the ORM, when primary key values needed to be fetched from newly insertedrows without executing row-at-a-time. Release 2.1 adds support for the useof monotonically increasing server side functions to be integrated withinthis system, with PG's uuidv7() construct as the current example.
• Greenlet is a fully optional dependency - SQLAlchemy's asyncio supportin version 2.1 remains dependent on greenlet to switch between asyncio andsynchronous internal logic. However, as greenlet continues to have sporadiccompatibility issues when new Python versions are released, it no longerinstalls automatically and must be installed separately, typically using thesqlalchemy[asyncio] target. This change also supports Python freethreading, as greenlet as of this writing is not yet compatible withfree-threaded Python builds

SQLAlchemy 2.1 includesover 90 individual documented changes, so be sureto check out not just theWhat's New in SQLAlchemy 2.1? migrationguide, but the detailed changelog atChangelogas well.

SQLAlchemy 2.1.0b1 by naming convention is a beta release, so only installswith pip if the--pre flag is included. Links to pypi forSQLAlchemy 2.1.0b1 are available on theDownload Page.

SQLAlchemy 2.0.45 is now available.

Links to the detailed changelog for 2.0.45 is atChangelog.

SQLAlchemy 2.0.45 is available on theDownload Page.

SQLAlchemy 2.0.44 is now available.

Release 2.0.44 comes as work on the 2.1 series continues with selectedissues and enhancements backported. Of note is this is the first releaseto be tested on free threaded Python versions.

Links to the detailed changelog for 2.0.44 is atChangelog.

SQLAlchemy 2.0.44 is available on theDownload Page.

SQLAlchemy 2.0.43 is now available.

Release 2.0.43 includes a fix for a regression introduced in the PostgreSQLdialect in 2.0.42, some ORM fixes and a new enhancement to "DBAPI autocommit"mode that should be useful in particular for MySQL/MariaDB environments thatmake use of this feature.

Links to the detailed changelog for 2.0.43 is atChangelog.

SQLAlchemy 2.0.43 is available on theDownload Page.