I want to say one of the BAQ Tech refs has this exact use case as an example of how to build recursive queries.
EDIT: It’s actually in the built-in help. Hit F1 and search for “Common Table Expression Query”
There’s other useful examples under the “Case Studies” topic.