Much like OutSystems abstracts code into visual drag-and-drop nodes and components, have a similar abstracted visual language for creating advanced SQL queries.
Huh, that is what aggregates are, or am I missing the intent of your idea?
Yes, aggregates are very close to that, but they often feel limited compared to advanced SQL queries. I guess my idea would be something like Aggregates V2, making aggregates much more flexible, almost eliminating the need to use advanced SQL queries.
Alright your idea is one of many previously posted, to include more features in aggregates to avoid the need to write advanced SQL queries.