LibSQL - JSON DB Type

[ainsleyclark]

What do you want to change?

Hi there,

It would be great if we can support json as an override in db_type as LibSQL and specifically providers such as Turso offer the extension. See: https://www.sqlite.org/json1.html

Currently, we have to override every column with a custom one.

https://github.com/sqlc-dev/sqlc/blob/df9413cf03462528e6f7d80784230f8769a120ba/internal/codegen/golang/sqlite_type.go#L13-L16

Thanks in advance.

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

Go