1 files changed, 8 insertions, 0 deletions
diff --git a/test/requirements.py b/test/requirements.py
index d31088e16..3c7a3fbb4 100644
--- a/test/requirements.py
+++ b/test/requirements.py
@@ -351,6 +351,14 @@ class DefaultRequirements(SuiteRequirements):
         return skip_if(exclude('mysql', '<', (4, 1, 1)), 'no subquery support')
 
     @property
+    def ctes(self):
+        """Target database supports CTEs"""
+
+        return only_if(
+            ['postgresql', 'mssql']
+        )
+
+    @property
     def mod_operator_as_percent_sign(self):
         """target database must use a plain percent '%' as the 'modulus'
         operator."""