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[]>(),; and I'm able to save data into it by passing an array of strings: ['Mary Shelley']. However, when I run a select on that schema, I get back a string of the json: "[\"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 is showing up correctly as string[]. But the data is a plain string.
Was this page helpful?