with recursive t(i, s) as (
select 0, 'foo'
union all
select i+1, s || 'bar'
from t
where i < 1)
select last(s order by i) as s
from t;