I built this some time ago to simplify an internal export process.
With some fiddling one could render and whole website with a single query :D .
Happy to answer any questions.
Thanks!