Bump sqlalchemy from 1.3.20 to 1.4.2

Bumps sqlalchemy from 1.3.20 to 1.4.2.

Release notes

Sourced from sqlalchemy's releases.

1.4.2

Released: March 19, 2021

orm

• [orm] [usecase] [dataclasses] Added support for the _orm.declared_attr object to work in the context of dataclass fields.

  References: #6100

• [orm] [bug] [dataclasses] Fixed issue in new ORM dataclasses functionality where dataclass fields on an abstract base or mixin that contained column or other mapping constructs would not be mapped if they also included a "default" key within the dataclasses.field() object.

  References: #6093

• [orm] [bug] [regression] Fixed regression where the _orm.Query.selectable accessor, which is a synonym for _orm.Query.__clause_element__(), got removed, it's now restored.

  References: #6088

• [orm] [bug] [regression] Fixed regression where use of an unnamed SQL expression such as a SQL function would raise a column targeting error if the query itself were using joinedload for an entity and was also being wrapped in a subquery by the joinedload eager loading process.

  References: #6086

• [orm] [bug] [regression] Fixed regression where the _orm.Query.filter_by() method would fail to locate the correct source entity if the _orm.Query.join() method had been used targeting an entity without any kind of ON clause.

  References: #6092

• [orm] [bug] [regression] Fixed regression where the SQL compilation of a Function would not work correctly if the object had been "annotated", which is an internal memoization process used mostly by the ORM. In particular it could affect ORM lazy loads which make greater use of this feature in 1.4.

  References: #6095

• [orm] [bug] Fixed regression where the ConcreteBase would fail to map at all when a mapped column name overlapped with the discriminator column name, producing an assertion error. The use case here did not function correctly in 1.3 as the polymorphic union would produce a query that ignored the discriminator column entirely, while emitting duplicate column warnings. As

... (truncated)

Commits

• See full diff in compare view