The following shows unambiguous examples of JSON dot notation usage.
Example
SELECT jsonCol.name FROM test.jsonTable WHERE id=1;
Result:
jsonCol.name ------------ Cameron
Example
SELECT jsonCol.numbers[1] FROM test.jsonTable WHERE id=1;
Result:
jsonCol.numbers[1] ------------------ 2
Example
SELECT new JSON('{"name" : "Cameron"}').name;
Result:
new JSON('{"name" : "Cameron"}').name ------------------------------------- Cameron