Retrieve JSON column value

[jbuiquan]

Hello,

I was wondering if it was possible to get a properly parsed object for a JSON column when retrieving data with getRowObjectsJson() ?
As of now I haven't find any solution other than applying a JSON.parse on every line retrieved for that particular column.
Is there any other type where i could obtain a parsed object ? I was thinking about using struct or map, but i haven't succeeded.

[jraymakers]

You could extend any of the converters, including the JsonDuckDBValueConverter, to do this. You'd just change the function for VARCHAR, because JSON columns use VARCHAR under the covers. That function receives the column type, and you can distinguish JSON columns from other VARCHARs by looking at the alias property of the type.

Using a STRUCT or MAP type could also be a good solution, if you can control how the data is structured. Storing data as one of those types likely to be significantly more efficient than using the JSON type.