SQLite Forum

Reference to RECURSIVE table column apparently not allowed in nested SELECT
Login
It should probably be documented that limit and offset require "constant expressions".  At the moment the documentation simply requires that they contain an expression that evaluates to an integer, and an expression includes a column reference.

The error message is merely wrong -- the error should be something along the lines that is is not a constant expression or something to that effect, not that the column cannot be found.