Do you mean something like:
```
create table t(x);
WITH RECURSIVE
cnt(x) AS (
SELECT 1
UNION ALL
SELECT x+1 FROM cnt
LIMIT 1000000
)
INSERT INTO t SELECT x FROM cnt;
```
?
Or perhaps,
```
create table x as
WITH RECURSIVE cnt(x)
AS (
SELECT 1
UNION ALL
SELECT x+1
FROM cnt
LIMIT 1000000
)
SELECT x FROM cnt;
```