Bonjour
I wonder if the DBQUERY plugin could accept a WITH clause in front of a SELECT statement.
It is still a SELECT after all ?
Cordialement
Philippe
I.E. something like:
WITH
SetA AS (SELECT bla1, bla2, ... FROM "TableA" WHERE ... ORDER BY ... LIMIT ... ),
SetB AS (SELECT bla1, bla2, ... FROM "TableB" WHERE ... ORDER BY ... LIMIT ... )
SELECT bla1, bla2, ... FROM SetA UNION ALL SELECT bla1, Bla2, ... FROM SetB;
that cannot be expressed as a "standard" UNION