There is no limitation against getting at view data using a select. Here is an overly simple example using a synchronous connection:
var conn:SQLConnection = new SQLConnection();
var sql:SQLStatement = new SQLStatement();
sql.sqlConnection = conn;
sql.text = "CREATE TABLE IF NOT EXISTS employees (id Integer, name String);";
sql.text = "INSERT INTO employees VALUES (1, 'Sam');";
sql.text = "INSERT INTO employees VALUES (2, 'Bob');";
sql.text = "CREATE VIEW IF NOT EXISTS emp_view AS SELECT name FROM employees WHERE name LIKE 'B%';";
sql.text = "SELECT * FROM emp_view;";
trace(ObjectUtil.toString(sql.getResult().data));Which outputs:(Array)#0 (Object)#1name = "Bob"
Thank you for your useful example. I created a database , tables and views directly from teh sqlite3 command line prompt, and now everything works perfectly. I'm suspecting Firefox SQliteManager Add-On as being the culprit in my failure to retreive data from SQLite via Air.