[Feature]: Missing JSON functions

[vicheanath]

Feature description

https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html

🎤 Pitch

https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html

[vicheanath]

• [ ] -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT().
• [ ] ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()).
• [x] JSON_ARRAY() Create JSON array
• [x] JSON_ARRAY_APPEND() Append data to JSON document
• [x] JSON_ARRAY_INSERT() Insert into JSON array
• [x] JSON_CONTAINS() Whether JSON document contains specific object at path
• [x] JSON_CONTAINS_PATH() Whether JSON document contains any data at path
• [x] JSON_DEPTH() Maximum depth of JSON document
• [x] JSON_EXTRACT() Return data from JSON document
• [x] JSON_INSERT() Insert data into JSON document
• [x] JSON_KEYS() Array of keys from JSON document
• [x] JSON_LENGTH() Number of elements in JSON document
• [x] JSON_MERGE() Merge JSON documents, preserving duplicate keys. Deprecated synonym for JSON_MERGE_PRESERVE() Yes
• [x] JSON_MERGE_PATCH() Merge JSON documents, replacing values of duplicate keys
• [x] JSON_MERGE_PRESERVE() Merge JSON documents, preserving duplicate keys
• [x] JSON_OBJECT() Create JSON object
• [x] JSON_OVERLAPS() Compares two JSON documents, returns TRUE (1) if these have any key-value pairs or array elements in common, otherwise FALSE (0) 8.0.17
• [x] JSON_PRETTY() Print a JSON document in human-readable format
• [x] JSON_QUOTE() Quote JSON document
• [x] JSON_REMOVE() Remove data from JSON document
• [x] JSON_REPLACE() Replace values in JSON document
• [x] JSON_SCHEMA_VALID() Validate JSON document against JSON schema; returns TRUE/1 if document validates against schema, or FALSE/0 if it does not 8.0.17
• [x] JSON_SCHEMA_VALIDATION_REPORT() Validate JSON document against JSON schema; returns report in JSON format on outcome on validation including success or failure and reasons for failure 8.0.17
• [x] JSON_SEARCH() Path to value within JSON document
• [x] JSON_SET() Insert data into JSON document
• [x] JSON_STORAGE_FREE() Freed space within binary representation of JSON column value following partial update
• [x] JSON_STORAGE_SIZE() Space used for storage of binary representation of a JSON document
• [x] JSON_TABLE() Return data from a JSON expression as a relational table
• [x] JSON_TYPE() Type of JSON value
• [x] JSON_UNQUOTE() Unquote JSON value
• [x] JSON_VALID() Whether JSON value is valid
• [x] JSON_VALUE() Extract value from JSON document at location pointed to by path provided; return this value as VARCHAR(512) or specified type 8.0.21
• [x] MEMBER OF() Returns true (1) if first operand matches any element of JSON array passed as second operand, otherwise returns false (0) 8.0.17

[invisal]

Thanks for working on this. We are really appreciating your work.