[sqlite] optimization for outer join with most simple views

Hello, I like to post this remark again as it seems closely related to "Query flattening for left joins involving subqueries on the right- hand side". I have a complete different reason though. For playing with sudoku solving, I have a table representing the digits 1..9: CREATE TABLE digi

[sqlite] optimization for outer join with most simple views

Hello, Suppose one has an expression on the columns of a single table, say x +y, and that this expression occurs in multiple queries. Then it is attractive to define it at a single place, using a view: create view v as select *, x+y as a from t; I had hoped that substituting such a view