Options 

• This is an optimization that will greatly help convert aggregate queries to OutSystems standard SQL. 
• The image below shows a way to get a sql code generated by aggregate.

• FormatExecutedSQL: This script aims to automate the conversion of SQL commands in the "Executed SQL" format generated by OutSystems to a standard SQL format, readable and reusable in traditional database tools. 
  • SQL: SQL in OutSystems format. 
  • FormattedSQL: Formatted SQL.