In addition to using the JSON functions it is possible to access elements
varchar field that holds JSON as if it was a field itself.
This allows for creation of indexes, searching and sorting efficiently.
Arrays can also be fetched as
strlst to make use of those features,
SELECT Json.$.name FROM tablename WHERE 'SQL' IN Json.$.skills[*];