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

JSON_INSERT(json_doc, path, val[, path, val] ...):
Inserts data into 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 contains a * or ** wildcard.

Use case

JSON_INSERT('{ "a": 1, "b": [2, 3]}', '$.a', 10, '$.c', '[true, false]')  -> {"a": 1, "b": [2, 3], "c": [true, false]}

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