What is the correct way to create a view in sqlite, according to the sqlite manual I can use these two types below
Table => CREATE TABLE "test" ("column1" TEXT, "column2" TEXT, "column3" TEXT)
1 => CREATE view "test_view" (col1, col3) as select "column1", "column3" from "test"
2 => CREATE view "test_view" as select "column1" as col1, "column3" as col3 from "test"
What's wrong with sqldb? Error in 1 statement!!!