SQLite Forum

Reference to RECURSIVE table column apparently not allowed in nested SELECT
Login
Agreed, absolutely.

But the OP's original query that prompted the question honestly does not break that rule either, it is very much exactly semantically equivalent (except for the self-referencing limit) to Keith's test.

Hence the confusion.