STRINGcolumns whose values are JSON strings.
JSON_MATCH(<column>, '<filterExpression>'). For example, to find all persons whose name is "adam", the query will look like:
JSON_MATCHpredicates. E.g. to find all persons who have addresses on "main st" and have addressed in "ca" (doesn't have to be the same address):
JSON_MATCHpredicates are required. E.g. to find all persons who have first address on "main st" and second address on "second st":
"$.addresses[*]"='main st'won't work.