René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Nested WITH doesn't work","articleBody":"### Version\n\n1.17.2\n\n### What happened?\n\nWhen a WITH is nested it doesn't work. The query works when running the query directly against postgres but fails when running in SQLC.\n\n### Relevant log output\n\n```shell\n/query.sql:9:1: relation \"summary\" does not exist\n```\n\n\n### Database schema\n\n```sql\n-- Example queries for sqlc\r\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: GetAuthor :one\r\nWITH person AS(\r\n    WITH summary AS(\r\n        WITH mb AS(\r\n            select\r\n                *\r\n            from authors\r\n        )\r\n        SELECT\r\n            bio\r\n        FROM mb\r\n        )\r\n    SELECT\r\n       count(*)\r\n    FROM summary\r\n)\r\n\r\nselect * from person;\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/e3b1e1370d95e38ad655fb46b019f20172272b6298e112ee9bf770878979bd00\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nPostgreSQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/hugosjoberg","@type":"Person","name":"hugosjoberg"},"datePublished":"2023-04-23T19:16:14.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2226/sqlc/issues/2226"}