Bump sqlalchemy from 1.3.23 to 1.4.1

[dependabot-preview[bot]]

Bumps sqlalchemy from 1.3.23 to 1.4.1.

Release notes

Sourced from sqlalchemy's releases.

1.4.1

Released: March 17, 2021

orm

• [orm] [bug] [regression] Fixed regression where producing a Core expression construct such as _sql.select() using ORM entities would eagerly configure the mappers, in an effort to maintain compatibility with the _orm.Query object which necessarily does this to support many backref-related legacy cases. However, core _sql.select() constructs are also used in mapper configurations and such, and to that degree this eager configuration is more of an inconvenience, so eager configure has been disabled for the _sql.select() and other Core constructs in the absence of ORM loading types of functions such as _orm.Load.

  The change maintains the behavior of _orm.Query so that backwards compatibility is maintained. However, when using a _sql.select() in conjunction with ORM entities, a "backref" that isn't explicitly placed on one of the classes until mapper configure time won't be available unless _orm.configure_mappers() or the newer _orm.registry.configure() has been called elsewhere. Prefer using _orm.relationship.back_populates for more explicit relationship configuration which does not have the eager configure requirement.

  References: #6066

• [orm] [bug] [regression] Fixed a critical regression in the relationship lazy loader where the SQL criteria used to fetch a related many-to-one object could go stale in relation to other memoized structures within the loader if the mapper had configuration changes, such as can occur when mappers are late configured or configured on demand, producing a comparison to None and returning no object. Huge thanks to Alan Hamlett for their help tracking this down late into the night.

  References: #6055

• [orm] [bug] [regression] Fixed regression where the _orm.Query.exists() method would fail to create an expression if the entity list of the _orm.Query were an arbitrary SQL column expression.

  References: #6076

• [orm] [bug] [regression] Fixed regression where calling upon _orm.Query.count() in conjunction with a loader option such as _orm.joinedload() would fail to ignore the loader option. This is a behavior that has always been very specific to the _orm.Query.count() method; an error is normally raised if a given _orm.Query has options that don't apply to what it is returning.

... (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 use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language - `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme Additionally, you can set the following in your Dependabot [dashboard](https://app.dependabot.com): - Update frequency (including time of day and day of week) - Pull request limits (per update run and/or open at any time) - Automerge options (never/patch/minor, and dev/runtime dependencies) - Out-of-range updates (receive only lockfile updates, if desired) - Security updates (receive only security updates, if desired)

[dependabot-preview[bot]]

Superseded by #111.