SQLAlchemy

library40 releases · 0 support lines

Releases

newest first

SQLAlchemyrel_2_1_0b32mo agoprerelease

Summary pending.

changelog ↗

SQLAlchemyrel_2_1_0b24mo agoprerelease

Summary pending.

changelog ↗

SQLAlchemyrel_2_1_0b17mo agoprerelease

Summary pending.

changelog ↗

SQLAlchemy2.0.521d ago

Summary pending.

changelog ↗

SQLAlchemyrel_2_0_512mo ago

Fixed subqueryload() with of_type() and and_() filters now correctly applies filter criteria instead of loading all related objects
Fixed Result.freeze() now properly tracks ambiguous column names to raise errors consistently instead of silently returning values
Fixed StatementLambdaElement now uses resolved expressions instead of cached ones, preventing stale parameter values when extending lambda statements
Fixed two-phase transaction recovery in PostgreSQL and hstore regex handling

changelog ↗

SQLAlchemyrel_2_0_503mo ago

Fixed ORM joinedload() with of_type() and and_() generating invalid SQL for joined-table subclasses
Fixed SessionEvents.do_orm_execute() hook leaking execution options between compilation passes, causing errors with selectinload() and immediateload()
Fixed with_polymorphic() on leaf or non-inherited classes failing with AttributeError
Fixed floor division (//) between Float/Numeric and Integer omitting FLOOR() wrapper on PostgreSQL and SQLite

changelog ↗

SQLAlchemyrel_2_0_494mo ago

Fixed Session.get() incorrectly bypassing the identity map when with_for_update=False was passed
Fixed chained joinedload() options not applying correctly with polymorphic relationships and subclass mappers
Fixed loader options with of_type() for polymorphic relationships not generating necessary clauses
Fixed various reflection and dialect issues in PostgreSQL, MSSQL, and Oracle

changelog ↗

SQLAlchemyrel_2_0_485mo ago

Fixed a critical bug where Engine connections created with DialectEvents.do_connect() event listeners received shared, mutable collections for connection arguments
This prevented unlimited growth of argument lists and eliminated shared state between concurrent connection calls
Resolves issues affecting do_connect routines using complex mutable authentication structures

changelog ↗

SQLAlchemyrel_2_0_476mo ago

Fixed ORM introspection failures with Python 3.14's PEP 649 feature when annotations contain non-present identifiers
Connection objects from Engine.raw_connection() now support context manager protocol for automatic pool return
Fixed PostgreSQL foreign key reflection to correctly parse ON DELETE and ON UPDATE clauses regardless of order
Fixed multiple PostgreSQL and SQLite ON CONFLICT issues with parameter handling and batch execution

to upgrade

Users of the MariaDB dialect should update code to specify both mariadb_with_parser and mariadb_using options (in addition to mysql_ prefixed options) to support both dialects, as mysql_ prefixed options will be deprecated.

changelog ↗

SQLAlchemyrel_2_0_467mo ago

Fixed type checking issues where ORM mapped classes and aliased entities can now be used as keys in result row mappings and join targets
Fixed PostgreSQL JSONB operators applying incorrect casts and JSONB subscription syntax generating invalid SQL for cast expressions
Fixed aiosqlite compatibility with version 0.22.0+ and added support for graceful connection termination
Added support for IF EXISTS clause when dropping indexes on SQL Server 2016 and later

changelog ↗

SQLAlchemyrel_2_0_458mo ago

Fixed Mapper.add_property() to work correctly when called during mapper event hooks like instrument_class() and after_mapper_constructed()
Fixed dataclass transformation failures in Python 3.14 when relationships reference classes in TYPE_CHECKING blocks
Improved reflection of CHECK constraints and constraint names on SQLite, including support for all quoting styles
Fixed PostgreSQL dialect to render constraint options in correct position and handle sequence nextval() properly with bulk inserts

changelog ↗

SQLAlchemy2.0.4410mo ago