Thanks!
I just fleshed out composing CTEs, which is a small step towards the broader goal of making composition easier: https://github.com/max-sixty/prql/commit/dc68fcaaceef26cc078...
Let me know if you have a good case of the sort of composition you find difficult in SQL (either here or in an issue). Thank you!