yql/essentials/tests/sql/suites/json/json_query/common_syntax.sql


1
2
3
4
5
6
7
8
9
10
11
12

/* syntax version 1 */
/* postgres can not */

-- Null handling
SELECT
    JSON_QUERY(NULL, "strict $.key"),
    JSON_QUERY(Nothing(Json?), "strict $.key");

-- Casual select
$json = CAST(@@{"key": [1, 2, 3]}@@ as Json);
SELECT
    JSON_QUERY($json, "strict $.key");