/* syntax version 1 */ /* postgres can not */ -- Accessing absent object member will cause empty result in lax mode $json = CAST("{}" as Json); SELECT JSON_QUERY($json, "lax $.key"), -- defaults to NULL ON EMPTY JSON_QUERY($json, "lax $.key" NULL ON EMPTY), JSON_QUERY($json, "lax $.key" EMPTY ARRAY ON EMPTY), JSON_QUERY($json, "lax $.key" EMPTY OBJECT ON EMPTY);