René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"nullable jsonb failed to specify its struct","articleBody":"### Version\n\n1.29.0\n\n### What happened?\n\nThe doc https://docs.sqlc.dev/en/stable/reference/datatypes.html#json says that we can specify the struct to a jsonb, but I tried to make a easy demo of doc's code and failed.\n\nThe generated model is\n```go\ntype Book struct {\n\tID   int32\n\tData types.BookData\n}\n```\nbut the doc says that will be\n```go\ntype Book struct {\n    Data *dto.BookData\n}\n```\n\nThis problem also happens in EditBookParams, I have provide the playground url: https://play.sqlc.dev/p/b1e8f0509a8d5c4e13f18db4b738040590eb1debc7439b4169314568d72e7742\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\nCREATE TABLE books (\n    id SERIAL PRIMARY KEY,\n    data jsonb\n);\n```\n\n### SQL queries\n\n```sql\n-- name: GetBookById :one\nSELECT * FROM books\nWHERE id = @id LIMIT 1;\n```\n\n### Configuration\n\n```yaml\nversion: \"2\"\n\nsql:\n  - engine: \"postgresql\"\n    queries: \"query.sql\"\n    schema: \"schema.sql\"\n    gen:\n      go:\n        package: \"database\"\n        out: \"database\"\n        sql_package: pgx/v5\n\n        emit_empty_slices: true\n        emit_pointers_for_null_types: true\n\n        overrides:\n          - column: \"books.data\"\n            go_type:\n              import: \"sqlc-test/types\"\n              package: \"types\"\n              type: \"BookData\"\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/b1e8f0509a8d5c4e13f18db4b738040590eb1debc7439b4169314568d72e7742\n\n### What operating system are you using?\n\nWindows\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/bhscer","@type":"Person","name":"bhscer"},"datePublished":"2025-07-24T03:41:58.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/4030/sqlc/issues/4030"}