[… to …] (SQL/JSON path array accessor)

The JSON path array accessor accepts a range of elements to pick:

SELECT JSON_QUERY('["A", "B", "C"]', '$[1 to 2]'
                  WITH ARRAY WRAPPER
                 )
  FROM …

The JSON path expression [1 to 2] in this example returns the JSON elements "A" and "B".

Related

• Primer: “JSON Path”

• Other SQL/JSON path array accessors:

  • Last element: [last]

  • Multiple subscripts: [<e>, <e>, …]

Normative References

The SQL/JSON path language first appeared in ISO/IEC 9075-2:2016 as part of optional feature T821, “Basic SQL/JSON query operators”.