-
Notifications
You must be signed in to change notification settings - Fork 111
Open
Description
The structure like this:
WITH hello_world AS (
WITH hello_another_world AS (
WITH hello_third_world AS (
SELECT
FROM
WHERE
ORDER BY
), hello_third_world_again AS (
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BY
), hello_another_world_again AS (
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BYGets formatted as:
WITH hello_world AS (
WITH hello_another_world AS (
WITH hello_third_world AS (
SELECT
FROM
WHERE
ORDER BY
),
hello_third_world_again AS (
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BY
),
hello_another_world_again AS (
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BY
)
SELECT
FROM
WHERE
ORDER BYIt is kind of a problem since nested CTEs tend to be used in complex queries in which indentation is a hint to the CTEs scope visibility.
ztane
Metadata
Metadata
Assignees
Labels
No labels