Since a while now, it's possible to convert an Aggregate to an SQL query. This is a great feature, but it has a number of limitations. For one, discoverability is low. Why not add it to the context menu when clicking an Aggregate?

Secondly, the limitations listed are annoying, if Service Studio can run the query on the database, it should be able to convert it to SQL. The limitations listed:

The option to convert an Aggregate to a SQL element will only be available if your Aggregate doesn't include:

• Structures in Sources
• Calculated Attributes
• Group By attributes
• Dynamic Sorts

It would be nice if this feature would be improved, so that all (or most) of these limitations are gone.