Is your feature request related to a problem or challenge?

as #9315 mentioned, generate_series is alias of range, it's result does not include the upper bound. it results the problem of Portability from other DBMS.

Describe the solution you'd like

the result of generate_series is same as that of postgresql, the range() funciton keeps the current result

 select generate_series(1,3);
 generate_series
-----------------
               1
               2
               3

select * from generate_series(1,3);
 generate_series
-----------------
               1
               2
               3

Describe alternatives you've considered

No response

Additional context

No response