[Feature][SDK] Transform support ARRAY() function

[emptyOVO]

Description

• parent issue: [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796
• from flinksql: https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/#value-construction-functions
• array(ANY1, ANY2, ...)--Returns an array created from a list of values (value1, value2, …).

Use case

No response

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