Bump sqlalchemy from 1.4.39 to 1.4.40

[dependabot[bot]]

Bumps sqlalchemy from 1.4.39 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)

[dependabot[bot]]

OK, I won't notify you again about this release, but will get in touch when a new version is available. If you'd rather skip all updates until the next major or minor version, let me know by commenting @dependabot ignore this major version or @dependabot ignore this minor version. You can also ignore all major, minor, or patch releases for a dependency by adding an ignore condition with the desired update_types to your config file.

If you change your mind, just re-open this PR and I'll resolve any conflicts on it.