1 files changed, 39 insertions, 0 deletions
diff --git a/vendor/ipl/sql/src/CommonTableExpressionInterface.php b/vendor/ipl/sql/src/CommonTableExpressionInterface.php
new file mode 100644
index 0000000..7e93bc8
--- /dev/null
+++ b/vendor/ipl/sql/src/CommonTableExpressionInterface.php
@@ -0,0 +1,39 @@
+<?php
+
+namespace ipl\Sql;
+
+/**
+ * Interface for CTEs via {@link with()}
+ */
+interface CommonTableExpressionInterface
+{
+    /**
+     * Get all CTEs
+     *
+     * [
+     *   [$query, $alias, $columns, $recursive],
+     *   ...
+     * ]
+     *
+     * @return array[]
+     */
+    public function getWith();
+
+    /**
+     * Add a CTE
+     *
+     * @param Select $query
+     * @param string $alias
+     * @param bool   $recursive
+     *
+     * @return $this
+     */
+    public function with(Select $query, $alias, $recursive = false);
+
+    /**
+     * Reset all CTEs
+     *
+     * @return $this
+     */
+    public function resetWith();
+}