Generate a range of values in Dremio

Hi there!
I have a question regarding creating a range of values in Dremio. I want to generate a table in a following format(this is just an example).

n
1
2
3
4
100

Remark: I want to be able to set the upper and lower border of the range like in generate-series function.
For example:
function(a, b), where a is a lower border and b is an upper border

As far as I know there is no generate_series function available in Dremio, so I am asking the community whether there is a possible workaround for this problem
Thanks)