JSON functions overview

The following table lists the JSON functions supported by seekdb.

Function	Description
JSON_ARRAY	Creates a JSON array.
JSON_ARRAYAGG	Aggregates results into a single JSON array.
JSON_ARRAY_APPEND	Appends the specified value to a JSON document.
JSON_APPEND	Appends the specified value to a JSON document.
JSON_ARRAY_INSERT	Inserts an array into a JSON document.
JSON_CONTAINS	Checks whether the specified JSON document is contained in the target JSON document.
JSON_CONTAINS_PATH	Checks whether the data in the specified path is contained in the target JSON document.
JSON_DEPTH	Returns the maximum depth of a JSON document.
JSON_EXTRACT	Returns data from a JSON document.
JSON_INSERT	Inserts data into a JSON document.
JSON_KEYS	Returns an array of keys corresponding to the specified path in a JSON document.
JSON_LENGTH	Returns the length of a JSON document.
JSON_MERGE	Merges multiple JSON documents.
JSON_MERGE_PATCH	Merges multiple JSON documents, and does not retain members with duplicate keys.
JSON_MERGE_PRESERVE	Merges multiple JSON documents.
JSON_OBJECT	Creates a JSON object.
JSON_OVERLAPS	Compares two JSON documents.
JSON_PRETTY	Prints a JSON document in a formatted manner.
JSON_QUOTE	Quotes a JSON document.
JSON_REMOVE	Removes data from a JSON document.
JSON_REPLACE	Replaces values in a JSON document.
JSON_SEARCH	Returns the path of a value in a JSON document.
JSON_SET	Inserts data into a JSON document.
JSON_STORAGE_SIZE	Returns the number of binary bytes stored in a JSON document.
JSON_TABLE	Extracts data from a JSON document and returns a relational table with specified columns.
JSON_TYPE	Returns the type of a JSON value.
JSON_UNQUOTE	Unquotes a JSON value.
JSON_VALUE	Extracts and returns a value from a JSON document at the specified path.
JSON_VALID	Checks whether a JSON value is valid.
JSON_OBJECTAGG	Returns a JSON object that contains key-value pairs.
MEMBER OF	Returns 1 if the retrieved element is the same as any element in the JSON array, otherwise returns 0.
JSON_SCHEMA_VALIDATION_REPORT	Returns 1 if the JSON document conforms to the JSON schema, otherwise returns 0.
JSON_SCHEMA_VALID	Returns a JSON schema validation report in JSON format.