5 replies

Json column type returning as plain string?

I have a schema for a json column (sqlite, proxy http driver) defined as:

 authors: text({ mode: 'json' }).notNull().$type<string[]>(),

 authors: text({ mode: 'json' }).notNull().$type<string[]>(),

; and I'm able to save data into it by passing an array of strings:

['Mary Shelley']

['Mary Shelley']

. However, when I run a select on that schema, I get back a string of the json:

"[\"Mary Shelley\"]"

"[\"Mary Shelley\"]"

. Curious if that's expected, and/or if there is a way to automatically parse the resulting json.

The type information for

authors

authors

is showing up correctly as

string[]

string[]

. But the data is a plain string.

Drizzle Team•16mo ago•