根据递归查询的结果创建一个表（带语句）

我想根据SQLite中的递归查询结果创建一个新的（持久）表。
例如，让我们创建一个包含列(n,fct)的表，其中n代表自然数，fct代表阶乘：

-- factorial of n = 0,1,...,5
WITH RECURSIVE fact_i (n,fct) AS (
VALUES (0,1)
UNION ALL
SELECT n+1,fct * (n+1) FROM fact_i
WHERE n <5)
SELECT * FROM fact_i;


结果

0|1
1|1
2|2
3|6
4|24
5|120


但是，我想将结果存储在一个持久表中，例如factorials。

我尝试过

CREATE TABLE factorials (n,fct) AS
WITH RECURSIVE fact_i (n,fct * (n+1) FROM fact_i
WHERE n <5)
SELECT * FROM fact_i;


或

WITH RECURSIVE fact_i (n,fct * (n+1) FROM fact_i
WHERE n <5)
CREATE TABLE factorials (n,fct) AS
SELECT * FROM fact_i;


但是两者都导致语法错误。
有没有办法在SQLite中创建这样的表？

是的，有可能（用附加的SELECT * FROM ()包装）：

CREATE TABLE factorials AS
SELECT *
FROM (
WITH RECURSIVE fact_i (n,fct) AS (
VALUES (0,1)
UNION ALL
SELECT n+1,fct * (n+1) FROM fact_i
WHERE n <5)
SELECT * FROM fact_i) s;


db<>fiddle demo

编辑：

实际上，您所需要做的就是从CREATE TABLE中删除列列表：

CREATE TABLE factorials AS
WITH RECURSIVE fact_i (n,fct * (n+1) FROM fact_i
WHERE n <5)
SELECT * FROM fact_i;


db<>fiddle demo2