René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Column does not exist error with jsonb_each in Postgres","articleBody":"### Version\n\n1.15.0\n\n### What happened?\n\nWhen running `generate`, I get an error about a column not existing even though it should and the select works if I run it directly against a database.\n\n### Relevant log output\n\n```shell\nquery.sql:3:8: column \"key\" does not exist\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE my_table (\r\n  data JSONB NOT NULL\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: GetData :one\r\n\r\nSELECT key, value\r\nFROM my_table, jsonb_each(data)\r\nLIMIT 1;\n```\n\n\n### Configuration\n\n```yaml\nversion: \"2\"\r\nsql:\r\n  - engine: \"postgresql\"\r\n    queries: \"query.sql\"\r\n    schema: \"schema.sql\"\r\n    gen:\r\n      go:\r\n        package: \"example\"\r\n        out: \"example\"\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/51d375a16d47e652835b91f5bcebfd41eeb62da8cfc09a01bcbad790862ac9d8\n\n### What operating system are you using?\n\nLinux, macOS\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/bretwalker","@type":"Person","name":"bretwalker"},"datePublished":"2022-12-02T14:00:20.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":5},"url":"https://github.com/1979/sqlc/issues/1979"}