CREATE TABLE t1(x, y);
INSERT INTO t1 VALUES(1, 2);
CREATE VIEW v1 AS SELECT * FROM (
WITH x1 AS (SELECT y, x FROM t1)
SELECT * FROM x1
);
SELECT * FROM v1
CREATE VIEW v3 AS SELECT * FROM main.t1;
WITH t1(a, b) AS ( SELECT 3, 4 ) SELECT * FROM v3;
CREATE VIEW v2 AS SELECT * FROM t1;
WITH t1(a, b) AS ( SELECT 3, 4 ) SELECT * FROM v2;