SQLite 3.27

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

CREATE TABLE MYTABLE (
  id INTEGER PRIMARY KEY,                   
  created TEXT,
  modified TEXT,
  anotherfield TEXT
);
INSERT INTO MYTABLE (created, modified, anotherfield) VALUES
  ('2020-12-31', '2021-01-27', 'text')
SELECT * FROM MYTABLE


id
created
modified
anotherfield


1
2020-12-31
2021-01-27
text


WITH RECURSIVE cte(x) AS (SELECT 1 UNION ALL SELECT x + 1 FROM cte WHERE x < 3)
INSERT INTO MYTABLE (created, modified, anotherfield)
SELECT m.created, m.modified, m.anotherfield 
FROM MYTABLE m CROSS JOIN cte c 
WHERE m.id = 1;
SELECT * FROM MYTABLE


id
created
modified
anotherfield


1
2020-12-31
2021-01-27
text

2
2020-12-31
2021-01-27
text

3
2020-12-31
2021-01-27
text

4
2020-12-31
2021-01-27
text

id	created	modified	anotherfield
1	2020-12-31	2021-01-27	text
2	2020-12-31	2021-01-27	text
3	2020-12-31	2021-01-27	text
4	2020-12-31	2021-01-27	text