René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Subquery Alias causing panic","articleBody":"I tried to do a more efficient distinct query (the second query) and noticed that the generation panics on the alias of a subquery. The first query shows a simpler example on how to cause this issue.\r\n\r\n```\r\npanic: walk: unexpected node type *pg_query.Alias\r\n```\r\n\r\n```sql\r\n-- schema.sql\r\nCREATE TABLE authors (\r\n  id BIGSERIAL PRIMARY KEY,\r\n  name TEXT NOT NULL,\r\n  bio TEXT\r\n);\r\n```\r\n\r\n```sql\r\n-- name: SubAuthors :many\r\nSELECT sub.name FROM (SELECT * FROM authors) sub\r\n\r\n-- name: ListDistinctAuthors :many\r\nWITH RECURSIVE temp (t) AS (\r\n    (SELECT name from authors LIMIT 1)\r\n    UNION ALL\r\n    (SELECT name FROM temp, LATERAL (SELECT name FROM authors where name \u003e t LIMIT 1) sub)\r\n)\r\nSELECT t from temp;\r\n```","author":{"url":"https://github.com/arddor","@type":"Person","name":"arddor"},"datePublished":"2019-12-12T10:00:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/153/sqlc/issues/153"}