René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Sqlc could not support table alias (error: table alias \"t1\" does not exist)","articleBody":"### Version\n\n1.18.0\n\n### What happened?\n\nSqlc could not support table alias, the sql example is in below.\r\n\r\nThe error message is \"table alias \"t1\" does not exist\"\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n          id   BIGINT PRIMARY KEY AUTO_INCREMENT,\r\n          name text      NOT NULL,\r\n          bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\n/* name: ListAuthors2 :many */\r\nselect * from (SELECT * FROM authors) as t1 where t1.id \u003e ?;\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\n_No response_\n\n### What database engines are you using?\n\n_No response_\n\n### What type of code are you generating?\n\n_No response_","author":{"url":"https://github.com/ankisme","@type":"Person","name":"ankisme"},"datePublished":"2023-07-04T09:58:09.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/2400/sqlc/issues/2400"}