Bump sqlalchemy from 1.3.24 to 2.0.20

[dependabot[bot]]

Bumps sqlalchemy from 1.3.24 to 2.0.20.

Release notes

Sourced from sqlalchemy's releases.

2.0.20

Released: August 15, 2023

orm

• [orm] [usecase] Implemented the "RETURNING '*'" use case for ORM enabled DML statements. This will render in as many cases as possible and return the unfiltered result set, however is not supported for multi-parameter "ORM bulk INSERT" statements that have specific column rendering requirements.

  References: #10192

• [orm] [bug] Fixed fundamental issue which prevented some forms of ORM "annotations" from taking place for subqueries which made use of _sql.Select.join() against a relationship target. These annotations are used whenever a subquery is used in special situations such as within _orm.PropComparator.and_() and other ORM-specific scenarios.

  This change is also backported to: 1.4.50

  References: #10223

• [orm] [bug] Fixed fundamental issue which prevented some forms of ORM "annotations" from taking place for subqueries which made use of _sql.Select.join() against a relationship target. These annotations are used whenever a subquery is used in special situations such as within _orm.PropComparator.and_() and other ORM-specific scenarios.

  This change is also backported to: 1.4.50

  References: #10223

• [orm] [bug] Fixed issue where the ORM's generation of a SELECT from a joined inheritance model with same-named columns in superclass and subclass would somehow not send the correct list of column names to the CTE construct, when the RECURSIVE column list were generated.

  References: #10169

• [orm] [bug] Fixed fairly major issue where execution options passed to _orm.Session.execute(), as well as execution options local to the ORM executed statement itself, would not be propagated along to eager loaders such as that of _orm.selectinload(), _orm.immediateload(), and _orm.subqueryload(), making it impossible to do things such as disabling the cache for a single statement or using schema_translate_map for a single statement, as well as the use of user-custom execution options. A change has been made where all user-facing execution options present for _orm.Session.execute() will

... (truncated)

Commits

• See full diff in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

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 ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

[dependabot[bot]]

Superseded by #2032.