[Feature][SDK] Transform SQL supports functions related to scale

[Zkplo]

Description

• parent issue [Umbrella] Tencent Rhino-bird: Expand InLong Transform functions #10796
• Postgresql Official Description: https://www.postgresql.org/docs/current/functions-math.html

scale ( numeric ) : Scale of the argument (the number of decimal digits in the fractional part)
min_scale ( numeric ): Minimum scale (number of fractional decimal digits) needed to represent the supplied value precisely
trim_scale ( numeric ): Reduces the value's scale (number of fractional decimal digits) by removing trailing zeroes

Use case

scale(8.4100) → 4
min_scale(8.4100) → 2
trim_scale(8.4100) → 8.41

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