convert duckdb sql to sqlite make wrong result

[l1t1]

I did it with

>>> import sqlglot
>>> sqlglot.transpile("WITH t AS( SELECT i, i*i*i*i*i AS i5 FROM range(1,5)t(i) )select * from t","duckdb","sqlite")
['WITH t AS (SELECT i, i * i * i * i * i AS i5 FROM RANGE(1, 5) AS t(i)) SELECT * FROM t']

and run in sqlite failed.

D:\>sqlite\sqlite345
SQLite version 3.45.0 2024-01-15 17:01:13 (UTF-16 console I/O)
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> WITH t AS (SELECT i, i * i * i * i * i AS i5 FROM RANGE(1, 5) AS t(i)) SELECT * FROM t;
Parse error: near "(": syntax error
  T i, i * i * i * i * i AS i5 FROM RANGE(1, 5) AS t(i)) SELECT * FROM t;
                                      error here ---^

there are two problems

1. range function does not exists in sqlite, sqlite has GENERATE_SERIES
2. sqlite does not support table(columns) alais syntax

[l1t1]

following sql works in sqlite

sqlite> WITH t AS (SELECT i, i * i * i * i * i AS i5 FROM (select value as i from generate_series(1, 5)) ) SELECT * FROM t;
1|1
2|32
3|243
4|1024
5|3125

[georgesittas]

Hey, thanks for the report - we're actively looking into this and should have a fix soon. Please make sure to file an issue for any future bugs you encounter so that they're properly tracked.

[georgesittas]

Solved in e50609b