René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Resolving references to CTE Columns fails","articleBody":"### Version\r\n\r\n1.27.0\r\n\r\n### What happened?\r\n\r\nResolving references to multiple CTE's with arguments fails.\r\n\r\nThis is a duplicate of #3219, but 3219 has been closed even thought the issue still persists and the relevant PR is not merged.\r\n\r\nPR to fix this issue: https://github.com/sqlc-dev/sqlc/pull/3220\r\n\r\n\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nsqlc generate failed.\r\n# package \r\nquery.sql:5:28: table alias \"t1_ids\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE t1\r\n(\r\n    id SERIAL NOT NULL PRIMARY KEY\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: CTERef :one\r\nWITH t1_ids AS (\r\n    SELECT id FROM t1\r\n)\r\nSELECT * FROM t1_ids WHERE t1_ids.id = sqlc.arg('id');\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [{\r\n    \"schema\": \"schema.sql\",\r\n    \"queries\": \"query.sql\",\r\n    \"engine\": \"postgresql\",\r\n    \"gen\": {\r\n      \"go\": {\r\n        \"out\": \"db\"\r\n      }\r\n    }\r\n  }]\r\n}\r\n​\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/9048b486f822c300301650867612e42bef8f8d512dfd12d84ad3a4cd210f4ef7\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/simonklee","@type":"Person","name":"simonklee"},"datePublished":"2024-09-06T08:50:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/3585/sqlc/issues/3585"}