1 files changed, 11 insertions, 2 deletions
diff --git a/services/app/src/Sql/QueryBuilder.php b/services/app/src/Sql/QueryBuilder.php
index 3a5443b..f6aee00 100644
--- a/services/app/src/Sql/QueryBuilder.php
+++ b/services/app/src/Sql/QueryBuilder.php
@@ -27,7 +27,7 @@ final class QueryBuilder
     ) {
     }
 
-    public function select(string $table): Select
+    public function select(string|Select $table): Select
     {
         return new Select($this, $table);
     }
@@ -57,6 +57,11 @@ final class QueryBuilder
         $this->conn->exec($sql);
     }
 
+    public function raw(string $sql): void
+    {
+        $this->conn->exec($sql);
+    }
+
     /**
      * @internal
      * @param Select $select
@@ -87,7 +92,11 @@ final class QueryBuilder
 
         return "SELECT " .
             implode(', ', $fields) .
-            " FROM $table" .
+            (
+                $table instanceof Select
+                    ? " FROM (" . $this->compileSelect($table) . ")"
+                    : " FROM $table"
+            ) .
             ($join !== null ? " $join->type $join->table ON $join->on" : '') .
             ($where !== '' ? " WHERE $where" : '') .
             (