WITH RECURSIVE lines(x, line, remain) AS (
  SELECT 1, substr(v, 0, 8) AS line, substr(v, 9) AS remain FROM i
  UNION ALL
    SELECT x + 1, substr(remain, 0, 8) AS line, substr(remain, 9) AS remain
    FROM lines
    WHERE remain != ''
)
SELECT x, lines FROM cnt