SQLite 循环语句？

SQLite中有没有类似的循环语句FOR .. in .. LOOP或类似的东西？我有两列StartRange, EndRange我需要在另一个表中插入整个序列。因此，如果StartRange是 1 并且EndRange是 3 需要用这些值进行三个插入1, 2, 3.

显然 SQLite 中的循环结构是与递归 https://sqlite.org/lang_with.html条款。 该文档链接包含从数到十的示例代码、Mandelbrot 集绘图仪和数独谜题求解器，全部采用纯 SQL 语言。 下面是一个计算斐波那契数列的 SQLite 查询，让您感受一下：

sqlite> WITH RECURSIVE
   ...>   fibo (curr, next)
   ...> AS
   ...>   ( SELECT 1,1
   ...>     UNION ALL
   ...>     SELECT next, curr+next FROM fibo
   ...>     LIMIT 100 )
   ...> SELECT group_concat(curr) FROM fibo;
1,1,2,3,5,8,13,21,34,55,89,144,233,377,610,987,1597,2584,4181,6765,10946,...

这是一个埃拉托斯特尼筛法 https://en.wikipedia.org/wiki/Sieve_of_Eratosthenes:

begin transaction;

drop table if exists naturals;
create table naturals
( n integer unique primary key asc,
  isprime bool,
  factor integer);

with recursive
  nn (n)
as (
  select 2
  union all
  select n+1 as newn from nn
  where newn < 1e4
)
insert into naturals
select n, 1, null from nn;

insert or replace into naturals
  with recursive
    product (prime,composite)
  as (
    select n, n*n as sqr
      from naturals
      where sqr <= (select max(n) from naturals)
    union all
    select prime, composite+prime as prod
    from
      product
    where
      prod <= (select max(n) from naturals)
  )
select n, 0, prime
from product join naturals
  on (product.composite = naturals.n)
;
commit;