A message from JMP creator John Sall
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.
Any update to this? Maybe with JMP 14?