René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Resolving reference to CTE column fails","articleBody":"### Version\n\n1.25.0\n\n### What happened?\n\nResolving references to multiple CTE's with arguments fails.\n\n### Relevant log output\n\n```shell\nsqlc generate failed.\r\n# package \r\nquery.sql:5:28: table alias \"t1_ids\" does not exist\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE t1\r\n(\r\n    id SERIAL NOT NULL PRIMARY KEY\r\n);\n```\n\n\n### SQL queries\n\n```sql\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');\n```\n\n\n### Configuration\n\n```yaml\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}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/9048b486f822c300301650867612e42bef8f8d512dfd12d84ad3a4cd210f4ef7\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/simonklee","@type":"Person","name":"simonklee"},"datePublished":"2024-02-24T23:47:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/3219/sqlc/issues/3219"}