yql/essentials/tests/sql/suites/json/combination/unwrapped.sql


1
2
3
4
5
6
7
8
9

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

$json = Unwrap(CAST(@@{"x": 1}@@ as Json));

SELECT
    JSON_EXISTS($json, "strict $.x"),
    JSON_VALUE($json, "strict $.x"),
    JSON_QUERY($json, "strict $");