Is your feature request related to a problem or challenge?

As said in PR #12922

If all UDF arguments are scalars, so should be the result.

In PR #12922, @joroKr21 implements it for math functions that use make_math_*_udf macros.

Maybe we should consider this problem for other scalar functions, such as math functions that don't use the macros.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response