René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Handle PostgreSQL system columns","articleBody":"### Version\r\n\r\n1.14.0\r\n\r\n### What happened?\r\n\r\nsqlc currently errors out with `column \"…\" does not exist` when referencing a PostgreSQL [system column](https://www.postgresql.org/docs/current/ddl-system-columns.html) (`tableoid`, `xmin`, `cmin`, `xmax`, `cmax` or `ctid`) in an SQL query.\r\n\r\nExample [db-fiddle](https://www.db-fiddle.com/f/xzTA5XuPmk2JLkWhJ6UJKd/0)\r\n\r\nNot sure if this should be a bug report or a feature request.\r\n\r\n### Relevant log output\r\n\r\n```shell\r\ncolumn \"ctid\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE test (\r\n  id INT\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\nSELECT ctid FROM test;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: 2\r\nsql:\r\n- schema: sql/schema.sql\r\n  queries: sql/queries.sql\r\n  engine: postgresql\r\n  gen:\r\n    go:\r\n      out: internal/sql\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/0a3172295b4a8b1a7dd1f78f56a864425724d1d5118c73a45f2fd313733c6910\r\n\r\n### What operating system are you using?\r\n\r\n_No response_\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/ndrpnt","@type":"Person","name":"ndrpnt"},"datePublished":"2022-07-14T23:30:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/1745/sqlc/issues/1745"}