sqlc-dev / sqlc

Generate type-safe code from SQL
https://sqlc.dev
MIT License
13.58k stars 812 forks source link

LibSQL - JSON DB Type #3590

Open ainsleyclark opened 2 months ago

ainsleyclark commented 2 months ago

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