Database Query Builder + JSON

Question

From what I've seen the Query Builder is not able to handle JSON. One it doesn't parse it, and two you cannot query the JSON because it hasn't been parsed.

So my question, is it possible to work with a column that has JSON in it just like it was structured data? Or can you only handle it by splitting up the JSON by building your own SQL statement?

For the environment it's JMP 13.2 and a PostgreSQL database.

Feli · Answer

We are having the same issue with our data base that has json as fields.

The Query Builder in JMP 15.2 recognizes the field as an character column, so you get an output column that includes one json per row per column in the data table as a char field. It might be possible to parse this column from character using JSL, but I was wondering whether it was possible to set a column to the new expression format for memory saving.

But parsing of json (or arrays) in a data base using the query builder would be quite nice.

DanielM · Answer

Any update to this?  Maybe with JMP 14?