In addition to using the JSON functions it is possible to access elements
in a 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,
e.g. SELECT Json.$.name FROM tablename WHERE 'SQL' IN Json.$.skills[*];