SQLite Forum

Given this  CTE:

<code>
WITH RECURSIVE
cnt(x) AS (
 SELECT 1
 UNION ALL
 SELECT x+1 FROM cnt
  LIMIT 1000000
)
SELECT x FROM cnt;
</code>

Is it possible to add an <i>INSERT INTO</i>  statement within the CTE to write the values to table?