SQL view support

[asmyasnikov]

Hi!
Thank you for your project.
I tried using sqlittle for read some databes (mbtiles), which contains views for representing row data as mbtiles standart tables. But I have fail =(
How to select data from views?
Can sqlittle support views?

[alicebob]

Hi! Thank you for your project. I tried using sqlittle for read some databes (mbtiles), which contains views for representing row data as mbtiles standart tables. But I have fail =( How to select data from views? Can sqlittle support views?

I expect views to be nothing more than a query, and not an actual table. So to select from the view SQLite needs to execute that query. Executing queries is something sqlittle can't do, unfortunately.