Sourced from sqlalchemy's releases.

2.0.42

Released: July 29, 2025

orm

• [orm] [usecase] Added dataclass_metadata argument to all ORM attribute constructors that accept dataclasses parameters, e.g. mapped_column.dataclass_metadata, relationship.dataclass_metadata, etc. It's passed to the underlying dataclass metadata attribute of the dataclass field. Pull request courtesy Sigmund Lahn.

  References: #10674

• [orm] [bug] Implemented the _orm.defer(), _orm.undefer() and _orm.load_only() loader options to work for composite attributes, a use case that had never been supported previously.

  References: #12593

• [orm] [bug] Fixed bug where the ORM would pull in the wrong column into an UPDATE when a key name inside of the ValuesBase.values() method could be located from an ORM entity mentioned in the statement, but where that ORM entity was not the actual table that the statement was inserting or updating. An extra check for this edge case is added to avoid this problem.

  References: #12692

engine

• [engine] Improved validation of execution parameters passed to the _engine.Connection.execute() and similar methods to provided a better error when tuples are passed in. Previously the execution would fail with a difficult to understand error message.

sql

• [sql] [usecase] The _sql.values() construct gains a new method _sql.Values.cte(), which allows creation of a named, explicit-columns CTE against an unnamed VALUES expression, producing a syntax that allows column-oriented selection from a VALUES construct on modern versions of PostgreSQL, SQLite, and MariaDB.

  References: #12734

• [sql] [bug] Fixed issue where select() of a free-standing scalar expression that

... (truncated)

• See full diff in compare view

Sourced from redis's releases.

6.4.0

Changes

🚀 New Features

• Added epsilon property to the vsim command (#3723)

🧰 Maintenance

• Updating the latest Redis image for github pipeline testing (#3726)

We'd like to thank all the contributors who worked on this release! @​htemelski-redis @​elena-kolevska @​petyaslavova @​vladvildanov

6.3.0

Changes

🚀 New Features

• Add support for new BITOP operations: DIFF, DIFF1, ANDOR, ONE (#3690)
• Support new VAMANA vector index type (#3702)
• Add new stream commands (#3711)
• add async Retry eq and hash & fix ExponentialWithJitterBackoff eq (#3668)

🐛 Bug Fixes

• Fixing sentinel command execution to allow returning of actual responses when meaningful - behaviour controlled by 'return_responses' argument. (#3191)
• Annotate deprecated_args decorator to preserve wrapped function type signature (#3701)
• Fix ConnectionPool to raise MaxConnectionsError instead of Connection… (#3698)
• add async Retry eq and hash & fix ExponentialWithJitterBackoff eq (#3668)
• SentinelManagedConnection searches for new master upon connection failure (#3560) (#3601)

🧰 Maintenance

• fix: avoid instantiating a connection on repr_ (#3653)
• Fixing the return type hint for the transaction method in the standalone client. (#3660)
• Bump rojopolis/spellcheck-github-actions from 0.48.0 to 0.49.0 (#3665)
• Dropping integration tests with Redis 6.2 from pipeline actions. (#3659)
• Remove deprecated arg from call to ClusterPipeline (#3670)
• TransactionStrategy reset: UNWATCH only when status is watching (#3671)
• KeyT for set operations (#3190)
• Removing references to old docs site 'https://redis-py.readthedocs.io/' replaced by 'https://redis.readthedocs.io/' (#3674)
• Removing unnecessary check for tests using AsyncMock (#3432)
• Updating test images for github pipeline execution (#3678)
• Updating the latest Redis image for pipeline testing (#3695)
• Bump rojopolis/spellcheck-github-actions from 0.49.0 to 0.51.0 (#3689)
• DOC-5225 testable probabilistic dt examples (#3691)
• Update README.md (#3699)
• Convert the value to int type only if it exists in CLIENT INFO (#3688)
• Fix compatibility with latest pytest-asyncio version(1.1.0) (#3708)
• DOC-5424 time series examples (#3705)
• Adding information in connection pool class doc string for available SSLConnection class, that can be used for SSL connections (#3710)

... (truncated)

• fff669d Updated package version
• 43ce2a4 Updating the latest Redis image for github pipeline testing (#3726)
• 64426cb Added epsilon property to the vsim command (#3723)
• 67ab74d Add new stream commands (#3711)
• 4c9512b Adding information in connection pool class doc string for available SSLConne...
• 31399ed SentinelManagedConnection searches for new master upon connection failure (#3...
• 7291deb add async Retry __eq__ and __hash__ & fix ExponentialWithJitterBackof...
• 4cf094f Fix ConnectionPool to raise MaxConnectionsError instead of Connection… (#3698)
• a001416 DOC-5424 time series examples (#3705)
• 2b1ff53 Fix compatibility with latest pytest-asyncio version(1.1.0) (#3708)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore <dependency name> major version will close this group update PR and stop Dependabot creating any more for the specific dependency's major version (unless you unignore this specific dependency's major version or upgrade to it yourself)
• @dependabot ignore <dependency name> minor version will close this group update PR and stop Dependabot creating any more for the specific dependency's minor version (unless you unignore this specific dependency's minor version or upgrade to it yourself)
• @dependabot ignore <dependency name> will close this group update PR and stop Dependabot creating any more for the specific dependency (unless you unignore this specific dependency or upgrade to it yourself)
• @dependabot unignore <dependency name> will remove all of the ignore conditions of the specified dependency
• @dependabot unignore <dependency name> <ignore condition> will remove the ignore condition of the specified dependency and ignore conditions