| Function |
Description |
| BSON_TO_JSON |
Converts a string that contains data that is formatted as BSON to a character string that contains data that is formatted as JSON. |
| JSON_ARRAY |
Generates a JSON array by explicitly listing the array elements by using an expression or by using a query. |
| JSON_OBJECT |
Generates a JSON object by using the specified key:value pairs.
If no key:value pairs are provided, an empty object is returned. |
| JSON_QUERY |
Returns an SQL/JSON value from the specified JSON text by using an SQL/JSON path expression. |
| JSON_TO_BSON |
Converts a string that contains data that is formatted for JSON to a binary string that contains data that is formatted as BSON. |
| JSON_VALUE |
Returns an SQL scalar value from JSON text, by using an SQL/JSON path expression. |
