With queries for DML
- DML queries should support as_with, but they don't
- DML queries that relies on With subqueries are broken
from querybuilder.schemas.helper import table
from querybuilder.queries import dql
@table
class A:
x : int
q = dql.Select(columns=(make_column(1),))
q.as_with("B")
A.insert(query=q.as_with("B").select())
The query produced should be:
WITH B as (SELECT 1) INSERT INTO A SELECT * FROM B
Edited by PAPERMAN Charles