summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/sql
diff options
context:
space:
mode:
authormike bayer <mike_mp@zzzcomputing.com>2021-05-11 18:09:36 +0000
committerGerrit Code Review <gerrit@ci3.zzzcomputing.com>2021-05-11 18:09:36 +0000
commitf6329060f1b2f5631deac3ca877c2ae19e3e6f36 (patch)
tree09edd4663f8f3dc107bd95539a0163da4d1fe3b7 /lib/sqlalchemy/sql
parente064ca8bc9e9a79f766acda9d718a96929400674 (diff)
parent07ab6441ea13be44f5aac6c53f2ab07369a082ac (diff)
downloadsqlalchemy-f6329060f1b2f5631deac3ca877c2ae19e3e6f36.tar.gz
Merge "allow CTE to be direct DML target"
Diffstat (limited to 'lib/sqlalchemy/sql')
-rw-r--r--lib/sqlalchemy/sql/selectable.py8
1 files changed, 7 insertions, 1 deletions
diff --git a/lib/sqlalchemy/sql/selectable.py b/lib/sqlalchemy/sql/selectable.py
index 43ba0da4c..7007bb430 100644
--- a/lib/sqlalchemy/sql/selectable.py
+++ b/lib/sqlalchemy/sql/selectable.py
@@ -1992,7 +1992,13 @@ class TableSample(AliasedReturnsRows):
return functions.func.system(self.sampling)
-class CTE(Generative, HasPrefixes, HasSuffixes, AliasedReturnsRows):
+class CTE(
+ roles.DMLTableRole,
+ Generative,
+ HasPrefixes,
+ HasSuffixes,
+ AliasedReturnsRows,
+):
"""Represent a Common Table Expression.
The :class:`_expression.CTE` object is obtained using the