Teiid supports the more standard recursive common table expression feature WITH Clause · Teiid Documentation which in many instances can be instead of the level/connect by feature. See Hierarchical and recursive queries in SQL - Wikipedia, the free encyclopedia or other similar discussions.
I need to create a query that generates a number sequence ..
A sequence with recursive common table expressions is more verbose. With Oracle syntax:
with x (col) as (select 1 as col from dual union all select col + 1 from x where col < 10000) select * from x
with x (col) as (select 1 as col union all select col + 1 from x where col < 10000) select * from x
The where clause controls how far the sequence goes.