A sub-select is not a recursive CTE; think more along the lines of "find me all ...

saurik on June 16, 2013 | parent | context | favorite | on: The lack of proper “alter table” support in SQLite

A sub-select is not a recursive CTE; think more along the lines of "find me all children of this Hacker News post #" where the scheme is simply "id | parent-id | poster | text": to do this requires recursion. I could totally be misunderstanding the reason you bring them up, however.

rogerbinns on June 16, 2013 [–]

I brought up subselects because they are a solution some of the time to some of the problems.