Using Aliased Query (CTE) with Union

[maen-allaga]

I'm trying to build a query that is equivalent to the one here:

WITH some_alias AS (
  SELECT *
  FROM table_1
  WHERE ....
)
SELECT col1, col2
FROM some_alias
WHERE condition1 AND condition2
UNION ALL
SELECT col3, col4
FROM some_alias
WHERE condition3 OR condition4

In a previous issue ( #359 ) there a mention to add the ctes to the first query, but here I want the CTE to be available to both parts of the union.
Is that possible? Is there a way to extend the _SetOperation to add a with_ part?

[tiagoskaneta]

@maen-allaga did you eventually figure this out? I have the same issue.

[maen-allaga]

@maen-allaga did you eventually figure this out? I have the same issue.

I created a wrapper around _SetOperations to handle the case.