Bump sqlalchemy from 1.4.31 to 1.4.40

[dependabot[bot]]

Bumps sqlalchemy from 1.4.31 to 1.4.40.

Release notes

Sourced from sqlalchemy's releases.

1.4.40

Released: August 8, 2022

orm

• [orm] [bug] Fixed issue where referencing a CTE multiple times in conjunction with a polymorphic SELECT could result in multiple "clones" of the same CTE being constructed, which would then trigger these two CTEs as duplicates. To resolve, the two CTEs are deep-compared when this occurs to ensure that they are equivalent, then are treated as equivalent.

  References: #8357

• [orm] [bug] A _sql.select() construct that is passed a sole '*' argument for SELECT *, either via string, _sql.text(), or _sql.literal_column(), will be interpreted as a Core-level SQL statement rather than as an ORM level statement. This is so that the *, when expanded to match any number of columns, will result in all columns returned in the result. the ORM- level interpretation of _sql.select() needs to know the names and types of all ORM columns up front which can't be achieved when '*' is used.

  If '* is used amongst other expressions simultaneously with an ORM statement, an error is raised as this can't be interpreted correctly by the ORM.

  References: #8235

orm declarative

• [orm] [declarative] [bug] Fixed issue where a hierarchy of classes set up as an abstract or mixin declarative classes could not declare standalone columns on a superclass that would then be copied correctly to a _orm.declared_attr callable that wanted to make use of them on a descendant class.

  References: #8190

engine

• [engine] [usecase] Implemented new _engine.Connection.execution_options.yield_per execution option for _engine.Connection in Core, to mirror that of the same yield_per <orm_queryguide_yield_per> option available in the ORM. The option sets both the _engine.Connection.execution_options.stream_results option at the same time as invoking _engine.Result.yield_per(), to provide the most common streaming result configuration which also mirrors that of the

... (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 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)