Support udf range

[smallzhongfeng]

Is your feature request related to a problem or challenge?

Currently our udf function does not have range. This is a commonly used function. I understand that I should add it.
try:
select range(10);
result:
Error: Plan("Invalid function 'range'.\nDid you mean 'nanvl'?")

And duckdb or clickhouse has supported it.
duckdb: https://duckdb.org/docs/archive/0.9.1/sql/functions/
clickhouse: https://clickhouse.com/docs/en/sql-reference/functions/array-functions

Describe the solution you'd like

Add the udf function.

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

Added as subtask of #6980

[Veeupup]

hi @alamb can I try to fix this issue? : )

[alamb]

sure -- thanks @Veeupup -- sorry for the delays in reviewing!