After using moonshine MongoDB pipelines I would say that it is a fantastic model.

You can sort of already do this in SQL with CTE* but a nice pipeline syntax would be welcome.

* Actually I believe that you can do more with CTE as you can mix the various steps in arbitrary ways