About

data generation with just sql is based on then generation of integer sequence via recursive query

Example: for mysql:

with recursive sequence as (
select 1 as id 
union all
select id + 1 as id from sequence
where id < 10)
select * from sequence