diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-05-11 08:39:24 -0400 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-05-11 08:39:24 -0400 |
commit | 07ab6441ea13be44f5aac6c53f2ab07369a082ac (patch) | |
tree | 4918bafb46577c55d7782ce4076f873b9681ab38 /lib/sqlalchemy/testing/plugin/pytestplugin.py | |
parent | 1a7d8005ccf4a48a3008caaf66b309be93287774 (diff) | |
download | sqlalchemy-07ab6441ea13be44f5aac6c53f2ab07369a082ac.tar.gz |
allow CTE to be direct DML target
Implemented support for a :class:`_sql.CTE` construct to be used directly
as the target of a :func:`_sql.delete` construct, i.e. "WITH ... AS cte
DELETE FROM cte". This appears to be a useful feature of SQL Server.
The CTE is now generally usable as a DML target table however
it's not clear if this syntax is valid beyond the use case of
DELETE itself.
Fixes: #6464
Change-Id: I3aac6fae2a1abb39bc0ffa87a044f5eb4f90f026
Diffstat (limited to 'lib/sqlalchemy/testing/plugin/pytestplugin.py')
0 files changed, 0 insertions, 0 deletions