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

JSON_REMOVE(json_doc, path[, path] ...):
Removes data from 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 or is $ or contains a * or ** wildcard.

Use case

JSON_REMOVE('["a", ["b", "c"], "d"]', '$[1]')   -> ["a", "d"]

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