SQL JSON functions

    OperatorDescription
    $Root element. All JSONPath expressions start with this operator.
    .<name>Child element in dot notation.
    [‘<name>’]Child element in bracket notation.
    [<number>]Array index.
    • To return the value of the key “x”:
      $.x -> 1
    • For a key that contains an array, to return an item in the array:
      $.y[1] -> 2