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

JSON_SET(json_doc, path, val[, path, val] ...):
Inserts or updates data in a JSON document and returns the result. Returns NULL if json_doc or path is NULL, or if path, when given, does not locate an object. Otherwise, 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_SET('{ "a": 1, "b": [2, 3]}', '$.a', 10, '$.c', '[true, false]')   -> {"a": 10, "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