On 5 Sep 2015, at 7:07pm, Darko Volaric <lists at darko.org> wrote: > That's not a valid reason since it's trivial for SQLite to transform > aliases by substituting their names with their definitions. It could be > handled in the parser code.
And by doing that you would not get optimization, since SQLite would have to work out the value once for the WHERE clause and once for the selected value. Which is what SQLite does now. Which is what you are complaining about in this thread. Remember: SQLite /does/ do this, even though it's not required by the SQL standard. Simon.
