Currently, get_json_object(json_txt, path) always returns null if json_txt is not a JSON object (e.g. is a JSON array) at the root level.
I have a table column of JSON arrays at the root level, but I can't parse it because of that.
get_json_object should accept any JSON value (string, number, object, array, true, false, null), not just object, at the root level. In other words, it should behave as if it were named get_json_value or simply get_json.
Per the JSON RFC, an array is indeed legal top-level JSON-text