]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
enable UPDATE..FROM for SQLite
authorMike Bayer <mike_mp@zzzcomputing.com>
Wed, 7 Sep 2022 21:13:23 +0000 (17:13 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 7 Sep 2022 23:10:53 +0000 (19:10 -0400)
commit885c61cf226695cafa12e56ed047ba761c2f7f93
tree661d781abe8ab09433c39a5c4bdd1e6d00d8a6bb
parent06fe424256a80b91e9ff87b3bbe12ea93bc59453
enable UPDATE..FROM for SQLite

The SQLite dialect now supports UPDATE..FROM syntax, for UPDATE statements
that may refer to additional tables within the WHERE criteria of the
statement without the need to use subqueries. This syntax is invoked
automatically when using the :class:`_dml.Update` construct when more than
one table or other entity or selectable is used.

Fixes: #7185
Change-Id: I27e94ace9ff761cc45e652fa1abff8cd1f42fec5
doc/build/changelog/unreleased_20/7185.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/sqlite/base.py
test/orm/test_update_delete.py
test/requirements.py