Comment by seanwoods

The topic of CTEs was recently discussed (with much vigor) on the SQLite users mailing list:

https://www.mail-archive.com/[email protected]/msg8119...