[Feature][SDK] Transform SQL supports "JSON_ARRAY_INSERT" function

[Zkplo]

Description

• parent issue [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796
• Mysql Official Description: https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html#function_json-array-insert

JSON_ARRAY_INSERT(json_doc, path, val[, path, val] ...):
Updates a JSON document, inserting into an array within the document and returning the modified document. Returns NULL if any argument is NULL. An error occurs if the json_doc argument is not a valid JSON document or any path argument is not a valid path expression or contains a * or ** wildcard or does not end with an array element identifier.

Use case

JSON_ARRAY_INSERT('["a", {"b": [1, 2]}, [3, 4]]','$[1]', 'x');  -> ["a", "x", {"b": [1, 2]}, [3, 4]]
JSON_ARRAY_INSERT('["a", {"b": [1, 2]}, [3, 4]]','$[100]', 'x');  -> ["a", {"b": [1, 2]}, [3, 4], "x"]
JSON_ARRAY_INSERT('["a", {"b": [1, 2]}, [3, 4]]','$[1].b[0]', 'x');  -> ["a", {"b": ["x", 1, 2]}, [3, 4]]
JSON_ARRAY_INSERT('["a", {"b": [1, 2]}, [3, 4]]','$[2][1]', 'y');  -> ["a", {"b": [1, 2]}, [3, "y", 4]]
JSON_ARRAY_INSERT('["a", {"b": [1, 2]}, [3, 4]]','$[0]', 'x', '$[2][1]', 'y');  -> ["x", "a", {"b": [1, 2]}, [3, 4]]

Are you willing to submit PR?

• Yes, I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct