2.0.30

Released: May 5, 2024

orm

• [orm] [bug] Added new attribute _orm.ORMExecuteState.is_from_statement to
  detect statements created using _sql.Select.from_statement(), and
  enhanced FromStatement to set _orm.ORMExecuteState.is_select,
  _orm.ORMExecuteState.is_insert,
  _orm.ORMExecuteState.is_update, and
  _orm.ORMExecuteState.is_delete according to the element that is
  sent to the _sql.Select.from_statement() method itself.

  References: #11220

• [orm] [bug] Fixed issue in _orm.selectin_polymorphic() loader option where
  attributes defined with _orm.composite() on a superclass would cause
  an internal exception on load.

  References: #11291

• [orm] [bug] [regression] Fixed regression from 1.4 where using _orm.defaultload() in
  conjunction with a non-propagating loader like _orm.contains_eager()
  would nonetheless propagate the _orm.contains_eager() to a lazy load
  operation, causing incorrect queries as this option is only intended to
  come from an original load.

  References: #11292

• [orm] [bug] Fixed issue in ORM Annotated Declarative where typing issue where literals
  defined using PEP 695 type aliases would not work with inference of
  Enum datatypes. Pull request courtesy of Alc-Alc.

  References: #11305

• [orm] [bug] Fixed issue in _orm.selectin_polymorphic() loader option where the
  SELECT emitted would only accommodate for the child-most class among the
  result rows that were returned, leading intermediary-class attributes to be
  unloaded if there were no concrete instances of that intermediary-class
  present in the result. This issue only presented itself for multi-level
  inheritance hierarchies.

  References: #11327

• [orm] [bug] Fixed issue in _orm.Session.bulk_save_objects() where the form of the
  identity key produced when using return_defaults=True would be
  incorrect. This could lead to an errors during pickling as well as identity
  map mismatches.

  References: #11332

• [orm] [bug] Fixed issue where attribute key names in _orm.Bundle would not be
  correct when using ORM enabled _sql.select vs.
  _orm.Query, when the statement contained duplicate column names.

  References: #11347

engine

• [engine] [bug] Fixed issue in the
  _engine.Connection.execution_options.logging_token option,
  where changing the value of logging_token on a connection that has
  already logged messages would not be updated to reflect the new logging
  token. This in particular prevented the use of
  _orm.Session.connection() to change the option on the connection,
  since the BEGIN logging message would already have been emitted.

  References: #11210

• [engine] [bug] Fixed issue in cursor handling which affected handling of duplicate
  _sql.Column or similar objcts in the columns clause of
  _sql.select(), both in combination with arbitary _sql.text()
  clauses in the SELECT list, as well as when attempting to retrieve
  _engine.Result.mappings() for the object, which would lead to an
  internal error.

  References: #11306

typing

• [typing] [bug] [regression] Fixed typing regression caused by #11055 in version 2.0.29 that
  added ParamSpec to the asyncio run_sync() methods, where using
  _asyncio.AsyncConnection.run_sync() with
  _schema.MetaData.reflect() would fail on mypy due to a mypy issue.
  Pull request courtesy of Francisco R. Del Roio.

  References: #11200

• [typing] [bug] Fixed issue in typing for _orm.Bundle where creating a nested
  _orm.Bundle structure were not allowed.

misc

• [bug] [test] Ensure the PYTHONPATH variable is properly initialized when
  using subprocess.run in the tests.

  References: #11268

• [bug] [installation] Fixed an internal class that was testing for unexpected attributes to work
  correctly under upcoming Python 3.13. Pull request courtesy Edgar
  Ramírez-Mondragón.

  References: #11334