On Jan 1, 2014, at 10:55 PM, James K. Lowden <jklow...@schemamania.org> wrote:
>> CTE ... bring capabilities to the users, by simplifying >> the use of the underlying tool. > > CTEs would add complexity, not simplify. Nonsense, dear Sir :) Yes, a ‘with’ clause is just syntax sugar providing named subqueries. But this sugar open the door to drastically different ways to write queries, bringing structure, clarity of thoughts and purpose to otherwise labyrinthine constructs. Think about ‘with’ clause as modern SQL syntax, in the same way as ANSI join syntax brings clarity of purpose to what otherwise would be a shambles of cross-purpose ‘where’ clauses. In short, a bit of syntactical sugar can do wonders for one’s diet :D Oh, and, also… Happy New Year! :) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users