CTE handling within Temporal joins and set operations
Created by: Piiit
Does the following query work? (Analogous for set ops)
with r as (select * from x)
SELECT * FROM (r PERIOD JOIN WITH (ts,te,ts,te) AS (newts, newte) s ON b=d) c;
Temporal joins and setops rewrite the query and use CTEs on top of it, do we overwrite given CTEs with that? Needs to be checked!