SQLite Forum

Reference to RECURSIVE table column apparently not allowed in nested SELECT
Login
Well Dominique, I was going to point out that while the base construct is a an "expression", that it can't reference its own query result, even of a previously established outer-query, and that this is made clear in the text further down...

But, surprisingly, I cannot actually find any such contradiction to the premise in any further down text.

From my reading of the current documentation, you are correct and there doesn't seem to be anything suggesting that "expr" in a LIMIT clause has any trouble with deriving it's value from the query itself in SQLite.

Interesting. Some experimentation seems to be needed.