René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[PostgresSQL] Failure to use GROUP BY for column output names when using subqueries","articleBody":"### Version\n\n1.15.0\n\n### What happened?\n\nWhen using a subquery, if I specify an output column name for GROUP BY, sqlc cannot compile it. if I execute SQL directly, it works fine.\r\n\r\nI am aware that when using PostgreSQL, column output names can be specified as GROUP BY. However, if I am mistaken, please let me know.\r\n\r\n\r\n\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE spam (\r\n    id SERIAL PRIMARY KEY\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: Spam :many\r\nSELECT\r\n  s.id AS \"s_id\"\r\nFROM\r\n  -- Using subqueries doesn't work.\r\n  (\r\n    SELECT\r\n      spam.id\r\n\tFROM spam\r\n  ) AS \"s\"\r\n-- Change this to s.id and it will work.\r\nGROUP BY s_id;\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/b3ae0c313bd30c061316dc729e285eba780ba4c7c94e4a44eaac81c619ce9c99\n\n### What operating system are you using?\n\nmacOS\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/voluntas","@type":"Person","name":"voluntas"},"datePublished":"2022-10-07T04:32:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/1886/sqlc/issues/1886"}