Apparently, while SQLite will happily let you write recursive common table expressions, it won't let you write MUTUALLY recursive common table expressions. This doesn't seem to be documented although I suppose you could infer it from the section I didn't read on how they work internally. Such a shame that I can't do this good and useful thing which I have good applications for.