CTE (Common Table Expressions) within CTE

[maoxingda]

Hope to support CTE (Common Table Expressions) in subqueries. Thank you.

insert into
    public.tgt_tbl1
(
    id
)
with
    t1 as
    (
        with
            t2 as
            (
                select
                    id
                from
                    public.src_tbl1
            )
        select
            id
        from
            t2
    )
select
    id
from
    t1
;

[maoxingda]

#476

[reata]

This potentially will be solved when we solve #476 and #481. Mark it as duplicate and keep it open for now.

[reata]

#476 (CTE within subquery) is now fixed. But looks like here we have CTE within CTE and they're not handled in a unified way. We still need to fix this issue separately.