[Feature][SDK] Transform SQL supports FORMAT 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/string-functions.html#function_format

FORMAT(X,D): Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result as a string. If D is 0, the result has no decimal point or fractional part. If X or D is NULL, the function returns NULL.

Use case

FORMAT(12332.123456, 4); -> '12,332.1235'
FORMAT(12332.1,4);       -> '12,332.1000'
FORMAT(12332.2,0);       -> '12,332'

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