CTE in CTE relation does not exist

[PatrLind]

Version

Other

What happened?

Version: v1.16.0

It seems like sqlc doesn't support CTE in CTE.

Possible duplicates or related issues: #1916, #1912

Relevant log output

The error message I get is:
`test.sql:1:1: relation "a" does not exist`

Database schema

No response

SQL queries

This is my test query:

WITH total AS (
    WITH a AS (
    	SELECT 1 AS col1, 2 AS col2
    ),
    b AS (
    	SELECT 1 AS col1, 3 AS col3
    )
    SELECT *
    FROM a
    FULL JOIN b USING (col1)
)
SELECT * FROM total;

Configuration

No response

Playground URL

https://play.sqlc.dev/p/ff29ae3267b95b9b42036ad8fdb76cf62d98d0b2c4f44a92bc028f16ebd88e06

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[kyleconroy]

This is partially fixed in v1.23.0 by enabling the database-backed query analyzer. You can play around with the working example on the playground

Star expansion for this query fails with the database-backed analyzer, which I'm tracking in #2915