Type: New Feature
Affects Version/s: V4.01_CS01
Fix Version/s: None
"JSON properties" are stream properties whose value is of media type application/json or one of its subtypes. They were introduced with
As outlined in OData Extension for JSON Data we need query capabilities on these properties.
- Specify a JSON Schema that describes/restricts the JSON stream values (
- Address parts of the JSON stream values in common expressions, e.g. in $filter, $compute, $orderby (this issue)
The first requirement can e.g. be solved via bound functions on JSON stream properties, e.g.
- extract/compute an OData value (primitive, complex, collection) from a JSON stream
- special case: extract/compute a JSON stream from a JSON stream
- special case: extract/compute a Boolean value from a JSON stream
These functions can be inspired by (or be direct wrappers for) the SQL/JSON functions
Google BigQuery Standard SQL has similar JSON functions JSON_EXTRACT and JSON_EXTRACT_SCALAR that use the same path syntax to address parts of the JSON value.
PostgreSQL has its own set of JSON Functions and Operators.