Hi Team,
It will be better if we can add a option for converting the advanced SQL Query to Aggregate.
Thanks & Regards,
Ramesh Sirvi
I agree this is doable, but if you could do that Advanced SQL as an Aggregate, why you did an Advanced SQL first?
I think there will be plenty of advanced SQL that cannot be converted to an aggregate, making such a function limited in use. If you have an sql that can be converted to aggregate, you should have been smarter and followed the best practise to try and use aggregates where possible over advanced SQL.
Yeah, you can do so much in SQL that you can't do in an Aggregate, this is really impossible to do right.