Usually for performance reasons of some tasks, advanced queries can get pretty big and complex. Perhaps one of the big thorns on "built to change" since little or no "sugar" is provided when doing adv. queries.
Allow calling something similar to stored procedures from within an advanced query. This could potentially greatly increasing readability and maintainability of these advanced queries.
Of course, these "stored procedures" would also be developed in SS.