Adding New functionality To Advance SQL Widget

Aggregates & Queries

I really like advance SQL widget . If very useful for situation where we cannot create the logic using the aggregate directly. 

But as we know SQL query can be written in many ways . Can we have any tool or logic where we can see the performance of the query that we have written (for complex query it can point that which part of query is taking more time ).

 Also if possible it would be better if widget is able to point to the line number if any error occurred while executing the query. 

[Kind of similar  functionality like sql profiler or Sql analyzer]

Created on 21 Feb
Comments (5)

Although i like the idea; I think it would be even better to keep focused on the Aggregate and have more functionality in it, so we don't have to use Advanced SQL; this will promote Visual / Low-Code.

Advanced SQL Widget must only be used by exception.

Changed the category to Aggregates & Queries

The problem is that when you use an Advanced SQL, you are also likely to be writing complex SQL. Since so many OutSystems customers are using the cloud offering which does not allow access to the database to use a tool like SQL Profiler, functionality like this is very important to solve problems.


I understand what you're saying but that is the opposite way that Outsystems is evolving.  Like Matthias wrote, maybe the best is to give more functionality to aggregates.



I like the idea, but like Matthias and Ricardo post we must focus in the aggregate evolution.