Download Latest Version 2.1.9 source code.zip (6.1 MB)
Home / rel_2_0_58
Name Modified Size InfoDownloads / Week
Parent folder
sqlalchemy-2.0.58-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp314-cp314-musllinux_1_2_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp313-cp313-musllinux_1_2_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp312-cp312-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp312-cp312-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp311-cp311-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp311-cp311-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314t-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314t-musllinux_1_2_aarch64.whl 2026-11-16 3.6 MB
sqlalchemy-2.0.58-cp314-cp314t-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.7 MB
sqlalchemy-2.0.58-cp312-cp312-musllinux_1_2_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp312-cp312-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.5 MB
sqlalchemy-2.0.58-cp311-cp311-musllinux_1_2_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp39-cp39-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp39-cp39-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp310-cp310-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp310-cp310-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp39-cp39-musllinux_1_2_aarch64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp39-cp39-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp310-cp310-musllinux_1_2_aarch64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp310-cp310-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp312-cp312-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp311-cp311-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp313-cp313-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp313-cp313-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp313-cp313-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314t-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp314-cp314t-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.5 MB
sqlalchemy-2.0.58-cp312-cp312-musllinux_1_2_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp311-cp311-musllinux_1_2_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-py3-none-any.whl 2026-11-16 2.0 MB
sqlalchemy-2.0.58-cp39-cp39-musllinux_1_2_x86_64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp310-cp310-musllinux_1_2_x86_64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp314-cp314t-musllinux_1_2_x86_64.whl 2026-11-16 3.6 MB
sqlalchemy-2.0.58-cp314-cp314t-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.6 MB
sqlalchemy-2.0.58-cp314-cp314-musllinux_1_2_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp314-cp314-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp313-cp313-musllinux_1_2_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp313-cp313-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.4 MB
sqlalchemy-2.0.58-cp38-cp38-musllinux_1_2_x86_64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp38-cp38-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp39-cp39-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp310-cp310-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp38-cp38-win_amd64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp38-cp38-win32.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp38-cp38-macosx_11_0_arm64.whl 2026-11-16 2.2 MB
sqlalchemy-2.0.58-cp38-cp38-musllinux_1_2_aarch64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58-cp38-cp38-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl 2026-11-16 3.3 MB
sqlalchemy-2.0.58.tar.gz 2026-11-16 10.0 MB
2.0.58 source code.tar.gz 2026-11-16 5.3 MB
2.0.58 source code.zip 2026-11-16 5.8 MB
README.md 2026-11-16 7.1 kB
Totals: 61 Items   184.6 MB 0

2.0.58

Released: November 16, 2026

orm

  • [orm] [bug] Fixed issue where deleting the parent object of a one-to-many relationship configured with _orm.relationship.post_update, such as the one-to-many side of a bidirectional post_update relationship, would emit the UPDATE that sets the foreign key of the remaining related objects to NULL twice: once within the regular UPDATE for those objects and again as the post-update. Only the post-update UPDATE is now emitted, and it is explicitly ordered to run before the DELETE of the parent row. Fix approach courtesy 18Abhinav07, with thanks to canblmz1 for the initial analysis.

    References: #10936

  • [orm] [bug] Fixed issue where criteria applied to a relationship using PropComparator.and_() within _orm.selectinload() or _orm.lazyload(), where the criteria referred to an _orm.aliased() construct against a subquery that's also the parent entity of the loader option, would load the related collection using the bound parameter values within that subquery from the first execution of the statement, once the statement was retrieved from the compiled cache.

    References: #13766

  • [orm] [bug] Fixed issue where loader options nested beneath a _orm.selectin_polymorphic() option, such as a _orm.selectinload() for a subclass-specific relationship, would be silently skipped when the enclosing relationship load was against an aliased entity such as one produced by _orm.with_polymorphic(), and a structurally different parent statement using the same loader options had been executed and cached previously. The selectin polymorphic loader now uses options from the cached statement in the same way as the selectin relationship loader already does.

    References: #13777

  • [orm] [bug] Fixed issue where loader options nested beneath a _orm.subqueryload() option against an aliased entity, such as subqueryload(A.bs.of_type(aliased(B))), would be silently skipped when the statement was served from the compiled cache and was constructed using a new _orm.aliased() or _orm.with_polymorphic() object, as is typical when the statement is built within a function. Nested options such as _orm.load_only(), _orm.undefer() and _orm.selectinload() took effect only the first time the statement was run. The subquery loader now uses options from the cached statement in the same way as the selectin relationship loader.

    References: #13779

  • [orm] [bug] Fixed issue where a subclass configured with _orm.Mapper.polymorphic_load set to "selectin" would cause a statement to raise ArgumentError when the statement selected from an _orm.aliased() or _orm.with_polymorphic() construct against the base class, or included another entity, along with loader options such as _orm.undefer() or _orm.selectinload() against that construct or entity. The automatic load of the subclass now leaves out loader options that refer to other entities, which were already applied by the enclosing statement.

    References: #13780

  • [orm] [bug] Fixed issue where joined eager loading that wraps the statement in a subquery, as occurs with LIMIT, OFFSET or DISTINCT, would populate joined inheritance subclass objects loaded by the main entity with column values from another row, when the statement also joined to an _orm.aliased() construct of that same subclass and referred to its columns, such as in ORDER BY.

    References: #13798

engine

  • [engine] [bug] Fixed issue in _engine.URL.update_query_pairs() where a key that was repeated with a sequence of strings as its value would produce a nested tuple in _engine.URL.query, causing the URL to fail to render as a string. Passing a sequence of strings as a value, which was indicated by the type annotations but not documented, is now documented, and the annotations for _engine.URL.update_query_pairs() and _engine.URL.update_query_dict() are corrected to accept any sequence of strings rather than only a list.

    References: #13770

sql

  • [sql] [bug] Fixed issue in cache key generation where calling _sql.Select.correlate() or _sql.Select.correlate_except() with None would not change the cache key of the _sql.Select, so that a statement which disables correlation, or correlates all FROM objects to enclosing SELECTs, could share a cached SQL string with an otherwise identical statement using the default auto-correlation behavior, leading to incorrect SQL being emitted for whichever statement was executed second.

    References: #13767

  • [sql] [bug] Fixed issue where a _sql.select() that refers to a CTE only within _sql.Select.select_from(), as the left side of _sql.Select.join_from(), or within a join that was followed by _sql.Select.with_only_columns(), would not be copied correctly by _sql.Select.params() or visitors.cloned_traverse(), such that the new parameter values could be ignored when the statement was invoked using the compiled cache, with the original values used instead. On the 2.1 series, where _sql.Select.params() no longer copies the statement, the issue still applies to visitors.cloned_traverse() and similar traversals.

    Also fixed a related issue where, if a traversal such as visitors.replacement_traverse() replaced the target of _sql.Select.join() or _sql.Select.join_from() with a Join, that join would render twice in the FROM clause of the resulting statement.

    References: #13791

asyncio

  • [asyncio] [bug] The asyncio.CancelledError that occurs frequently for tasks cancelled under anyio, where the connection is nonetheless successfully terminated, is now logged by the connection pool at DEBUG level rather than ERROR.

    References: #13772

postgresql

  • [postgresql] [bug] Fixed issue where reflection of PostgreSQL columns of type tsquery or regconfig would return NullType and emit a warning, even though the _postgresql.TSQUERY and _postgresql.REGCONFIG types are provided by the PostgreSQL dialect. These types are now mapped for reflection in the same way as _postgresql.TSVECTOR. Pull request courtesy Lushiyao5.

    References: #13762

Source: README.md, updated 2026-11-16