1 files changed, 12 insertions, 0 deletions
diff --git a/app/models/concerns/as_cte.rb b/app/models/concerns/as_cte.rb
new file mode 100644
index 00000000000..aa38ae3a9c1
--- /dev/null
+++ b/app/models/concerns/as_cte.rb
@@ -0,0 +1,12 @@
+# frozen_string_literal: true
+
+# Convert any ActiveRecord::Relation to a Gitlab::SQL::CTE
+module AsCte
+  extend ActiveSupport::Concern
+
+  class_methods do
+    def as_cte(name, **opts)
+      Gitlab::SQL::CTE.new(name, all, **opts)
+    end
+  end
+end