--- json_path_exists ---
SELECT json_path_exists(parse_json('{"a": 1, "b": 2}'), '$.a');

+--------------------------------------------------------------------+
| json_path_exists(parse_json(Utf8("{"a": 1, "b": 2}")),Utf8("$.a")) |
+--------------------------------------------------------------------+
| true                                                               |
+--------------------------------------------------------------------+

SELECT json_path_exists(parse_json('{"a": 1, "b": 2}'), '$.c');

+--------------------------------------------------------------------+
| json_path_exists(parse_json(Utf8("{"a": 1, "b": 2}")),Utf8("$.c")) |
+--------------------------------------------------------------------+
| false                                                              |
+--------------------------------------------------------------------+

SELECT json_path_exists(parse_json('[1, 2]'), '[0]');

+----------------------------------------------------------+
| json_path_exists(parse_json(Utf8("[1, 2]")),Utf8("[0]")) |
+----------------------------------------------------------+
| true                                                     |
+----------------------------------------------------------+

SELECT json_path_exists(parse_json('[1, 2]'), '[2]');

+----------------------------------------------------------+
| json_path_exists(parse_json(Utf8("[1, 2]")),Utf8("[2]")) |
+----------------------------------------------------------+
| false                                                    |
+----------------------------------------------------------+

SELECT json_path_exists(parse_json('[1, 2]'), 'null');

+-----------------------------------------------------------+
| json_path_exists(parse_json(Utf8("[1, 2]")),Utf8("null")) |
+-----------------------------------------------------------+
| false                                                     |
+-----------------------------------------------------------+

SELECT json_path_exists(parse_json('null'), '$.a');

+--------------------------------------------------------+
| json_path_exists(parse_json(Utf8("null")),Utf8("$.a")) |
+--------------------------------------------------------+
| false                                                  |
+--------------------------------------------------------+

--- json_path_match ---
SELECT json_path_match(parse_json('{"a": 1, "b": 2}'), '$.a == 1');

+------------------------------------------------------------------------+
| json_path_match(parse_json(Utf8("{"a": 1, "b": 2}")),Utf8("$.a == 1")) |
+------------------------------------------------------------------------+
| true                                                                   |
+------------------------------------------------------------------------+

SELECT json_path_match(parse_json('{"a":1,"b":[1,2,3]}'), '$.b[0] > 1');

+-----------------------------------------------------------------------------+
| json_path_match(parse_json(Utf8("{"a":1,"b":[1,2,3]}")),Utf8("$.b[0] > 1")) |
+-----------------------------------------------------------------------------+
| false                                                                       |
+-----------------------------------------------------------------------------+

SELECT json_path_match(parse_json('{"a":1,"b":[1,2,3]}'), '$.b[1 to last] >= 2');

+--------------------------------------------------------------------------------------+
| json_path_match(parse_json(Utf8("{"a":1,"b":[1,2,3]}")),Utf8("$.b[1 to last] >= 2")) |
+--------------------------------------------------------------------------------------+
| true                                                                                 |
+--------------------------------------------------------------------------------------+

SELECT json_path_match(parse_json('{"a":1,"b":[1,2,3]}'), 'null');

+-----------------------------------------------------------------------+
| json_path_match(parse_json(Utf8("{"a":1,"b":[1,2,3]}")),Utf8("null")) |
+-----------------------------------------------------------------------+
|                                                                       |
+-----------------------------------------------------------------------+

SELECT json_path_match(parse_json('null'), '$.a == 1');

+------------------------------------------------------------+
| json_path_match(parse_json(Utf8("null")),Utf8("$.a == 1")) |
+------------------------------------------------------------+
|                                                            |
+------------------------------------------------------------+