René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Unable to use set returning functions in from clause with ordinality","articleBody":"### Version\r\n\r\n1.21.0\r\n\r\n### What happened?\r\n\r\ncolumn  does not exist\r\n\r\n### Relevant log output\r\n\r\n```shell\r\ncolumn \"item_object\" does not exist\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n_No response_\r\n\r\n### SQL queries\r\n\r\n```sql\r\nSELECT code,arr.item_object-\u003e\u003e 'code'  as resource_code\r\nFROM sys_actions,\r\n    jsonb_array_elements(resources) with ordinality arr(item_object, resource)\r\n    WHERE item_object-\u003e\u003e'resource' = sqlc.arg('resource')\r\n    LIMIT 1;\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\nsql:\r\n  - schema: \"./sql/schema/\"\r\n    queries: \"./sql/query/\"\r\n    engine: \"postgresql\"\r\n    gen:\r\n      go:\r\n        package: \"queries\"\r\n        out: \"internal/data/queries\"\r\n        sql_package: \"pgx/v5\"\r\n        emit_json_tags: true\r\n        emit_empty_slices: false\r\n        emit_result_struct_pointers: true\r\n        emit_exported_queries: true\r\n        emit_methods_with_db_argument: false\r\n        emit_pointers_for_null_types: true\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/4b891b0542344db335f87e02995f28a3d2d98a0b6821747938ceecf73fc38a46\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\n_No response_\r\n\r\n### What type of code are you generating?\r\n\r\n_No response_","author":{"url":"https://github.com/Lay523","@type":"Person","name":"Lay523"},"datePublished":"2023-09-14T17:09:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/2731/sqlc/issues/2731"}