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.

sqlc/internal/codegen/golang/sqlite_type.go

Lines 13 to 16 in df9413c

	func sqliteType(req *plugin.GenerateRequest, options *opts.Options, col *plugin.Column) string {
	dt := strings.ToLower(sdk.DataType(col.Type))
	notNull := col.NotNull || col.IsArray
	emitPointersForNull := options.EmitPointersForNullTypes

Thanks in advance.

What database engines need to be changed?

SQLite

What programming language backends need to be changed?

Go