[Feature][SDK] Transform SQL supports "JSON_ARRAY_APPEND" 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-append

JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...):
Appends values to the end of the indicated arrays within a JSON document and returns the result. 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.

Use case

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

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