Hacker News new | ask | show | jobs
by seanwoods 4538 days ago
The topic of CTEs was recently discussed (with much vigor) on the SQLite users mailing list:

https://www.mail-archive.com/sqlite-users@sqlite.org/msg8119...
1 comments
fphhotchips 4538 days ago
"as long as the 'RECURSIVE' part of CTE is ignored."... To me, the recursive part of CTEs is half the point! All the other stuff is syntactic sugar that can be done elsewhere, but recursion is a function that I'm unable to find another method for elsewhere in the language.

Note: I have far more SQL Server experience than I do with any other DBMS.

link