SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table (id INTEGER PRIMARY KEY, name TEXT NOT NULL DEFAULT 'somename');
✓
WITH cte AS (
  SELECT 1 nr
  UNION ALL
  SELECT nr + 1
  FROM cte
  WHERE nr < 5
)
INSERT INTO my_table(rowid)
SELECT nr FROM cte
✓
SELECT * FROM my_table


id
name


1
somename

2
somename

3
somename

4
somename

5
somename


WITH cte AS (
  SELECT MAX(rowid) + 1 nr FROM my_table
  UNION ALL
  SELECT nr + 1
  FROM cte
  WHERE nr < (SELECT MAX(rowid) + 5 FROM my_table)
)
INSERT INTO my_table(rowid)
SELECT nr FROM cte
✓
SELECT * FROM my_table


id
name


1
somename

2
somename

3
somename

4
somename

5
somename

6
somename

7
somename

8
somename

9
somename

10
somename

id	name
1	somename
2	somename
3	somename
4	somename
5	somename
6	somename
7	somename
8	somename
9	somename
10	somename