• Try this one:

    with t as (select 1 x

    union all

    select x + 1

    from t

    where x < 100)

    select x

    from t