René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Trouble getting `emit_pointers_for_null_types` to apply to SQLite target","articleBody":"### Version\n\n1.24.0\n\n### What happened?\n\nI'm having some trouble getting the `emit_pointers_for_null_types` option to apply to a SQLite schema \u0026 queries, i.e. `sql.Null*` types aren't replaced with their pointer primitive variants. I've checked that other kinds of Go options work correctly, like `emit_result_struct_pointers`, `emit_interface`, and `emit_json_tags`, but not the null type option. I produced a minimal example that reproduces my issue in [this playground link](https://play.sqlc.dev/p/3d5b8939ebe833a68c11808b30ed27c0907bd2cbaf9422951775e7de6349e949). Not sure if this is a SQLite specific issue, since we have a similar Postgres schema where `emit_pointers_for_null_types` works fine.\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE dummy (\r\n  \"id\" text NOT NULL PRIMARY KEY,\r\n  \"col_1\" text\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: GetDummy :one\r\nSELECT * FROM dummy WHERE id = ?1;\r\n\r\n-- name: GetDummies :many\r\nSELECT * FROM dummy;\r\n\r\n-- name: CreateDummy :one\r\nINSERT INTO dummy (id, col_1) VALUES (?1, ?2)\r\nRETURNING *;\r\n\r\n-- name: UpdateDummy :one\r\nUPDATE dummy SET col_1 = ?2 WHERE id = ?1\r\nRETURNING *;\r\n\r\n-- name: DeleteDummy :exec\r\nDELETE FROM dummy WHERE id = ?1;\n```\n\n\n### Configuration\n\n```yaml\nversion: \"2\"\r\nsql:\r\n- schema: \"schema.sql\"\r\n  queries: \"query.sql\"\r\n  engine: \"sqlite\"\r\n  gen:\r\n    go:\r\n      package: \"sqlc\"\r\n      out: \"./\"\r\n      emit_pointers_for_null_types: true\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/3d5b8939ebe833a68c11808b30ed27c0907bd2cbaf9422951775e7de6349e949\n\n### What operating system are you using?\n\nmacOS\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/ddowl","@type":"Person","name":"ddowl"},"datePublished":"2024-01-30T22:57:40.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3167/sqlc/issues/3167"}