René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQLite JSONB not coerced if type is capitalized.","articleBody":"### Version\n\n1.30.0\n\n### What happened?\n\n#3968  introduced coercing a column to json if its type is jsonb. However, if the type is given as JSONB the coercion is not applied.\n\n**With capitalized `JSONB` type**\n```go\nconst listSensors = `-- name: ListSensors :many\nSELECT id, name, description, properties, created_at, updated_at, deleted_at, thing_id, feature_id FROM sensors WHERE deleted_at is NULL AND (CAST(?1 AS BOOLEAN) IS FALSE OR thing_id IN (/*SLICE:thing_ids*/?)) ORDER BY created_at\n`\n```\n\n**With uncapitalized `jsonb` type**\n```go\nconst listSensors = `-- name: ListSensors :many\nSELECT id, name, description, json(properties), created_at, updated_at, deleted_at, thing_id, feature_id FROM sensors WHERE deleted_at is NULL AND (CAST(?1 AS BOOLEAN) IS FALSE OR thing_id IN (/*SLICE:thing_ids*/?)) ORDER BY created_at\n`\n```\n\n### Relevant log output\n\n```shell\n\n```\n\n### Database schema\n\n```sql\nCREATE TABLE things (\n   id INTEGER PRIMARY KEY NOT NULL,\n   properties JSONB NOT NULL DEFAULT (JSONB('{}'))\n);\n\nCREATE TABLE things_2 (\n   id INTEGER PRIMARY KEY NOT NULL,\n   properties jsonb NOT NULL DEFAULT (jsonb('{}'))\n);\n```\n\n### SQL queries\n\n```sql\n-- name: ListThings :many\nselect * from things;\n\n-- name: ListThings2 :many\nselect * from things_2;\n```\n\n### Configuration\n\n```yaml\n\n```\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nSQLite\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/TimVosch","@type":"Person","name":"TimVosch"},"datePublished":"2026-03-11T10:58:21.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/4337/sqlc/issues/4337"}