SQL/JSON Syntax Improvements

You can now express more complex SQL/JSON queries and express some queries more succinctly.

  • New SQL function JSON_SCALAR accepts a scalar instance of a SQL data type and returns a scalar JSON value as an instance of JSON data type.
  • New JSON path-language item methods support JSON_SCALAR: float(), double(), binary(), ymInterval(), and dsInterval().
  • The JSON path-language and dot-notation syntax support new, aggregate item methods: avg(),  count(), minNumber(), maxNumber(), minString(), maxString()sum().
  • You can now express more complex SQL/JSON queries and express some queries more succinctly, and SQL/JSON path-expression syntax for array steps is improved.

Related Topics