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?
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?