This will be really time/effort saving. 

There should be an option to create dummy structure for non select queries.

I was also about to add same idea. Thanks man.

With a simple button "Create Structure" in the SQL, a lot of time could be saved building automatically a structure that is read from the query fields:

I can have an advanced SQL query that selects more than 10 columns, and maybe I would want only to test some behavior, and I cannot do so if I don't create a structure first. Then, if something changes (and it normally does) I have to go and edit the structure again. Structure creation should be automatically, based on the Advanced SQL Query output.

since you know which tables and fields are coming back for the SQL statement, you can automatically create the output structure for the SQL statement. If you don't know the type of data in a field, make it a TEXT type. But if I do something like this:

select {Car}.[Id] as CarId, {Owner}.[Id] as OwnerId from

{Car} inner join {Owner} on {Car}.[OwnerId] = {Owner}.[Id]

You know the structure will be like this:

CarOwner{

CarId: CarIdentifier,

OwnerId: OwnerIdentifier

}

OS doesn't need to make me manually create that structure and add it to the SQL Statement. This will save SOOO much time.

perhaps a duplicate of this idea https://www.outsystems.com/ideas/2682/Automatic+creation+of+structures+when+working+with+Advanced+SQL+Queries

Hi Team,

Please gives us option in advanced SQL to auto suggest/create relevant structure with the same definition.

Thanks!

It is often a pain to write or update structures that are required for use in SQL queries so would be ideal to be able to write the SQL and as long as it is valid, be able to create a structure off of the Select statement.  The update may be more of a challenge but if done well it could ensure consistency between columns in structures vs query.

Sometimes when you need that specific output, the only way is to create an advanced SQL.

This requires an output structure that matches the output of the query.

My current way of work is to write the SQL, then go to data tab and create the structure needed. Go back to the advanced SQL and add the structure.

The idea:

Add a function in the Create Advanced SQL "Create structure based on current SQL".

This would help save some time. Perhaps after this we can also have the option to update the current structure when the SQL had changed.

Hi Stefano Valente,

Great findings, it will be really helpful once it got implemented.

Regards,

Sreejith Surendran

Really good Thought and will Great help for Oustsystems Dev

This would be a good accelerator 

this accelerator would be welcome, because today we have to assemble the structure.

This frustration, that I share with you, has been around since 2010, see this idea.

The option to create a structure in one click that matches the current advanced query output.

e.g. I have  a query that returns 5 columns with datatype text -> press button -> creates a structure with 5 text attributes.

Hi Thibaut,

Though not possible directly, there's a workaround: first, create a Local Variable, and via the Data Type dropdown select "SQL1 Record Type" (where "SQL1" is the name of your SQL). Next, right-click the local variable for the context menu, and select "Create Structure from Data Type", and a structure will be created (and the local variable will get that structure as its Data Type). This also works with Aggregates. Note that if the SQL or Aggregate only returns a single Entity, the "Create Structure from Data Type" is not possible, as the data type of the local variable will already be the Entity Record, instead of a Record with entity records.

@Thibaut G ,

see also this idea, it has existed for more than 12 years, and has been labeled as 'not right now', so I wouldn't expect anything to change soon.  Maybe go like that idea, maybe it can be merged...

and there are lots of similar or related ideas, search the ideas section with 'sql output' if you are interested.

@Kilian Hekhuis , that sounded interesting, so i wanted to try, but I can't manage it, the option "SQL1 Type" in the dropdown only appears after i have already choosen a (set of) existing structures or entities as output for my SQL, so this doesn't help solve the annoying part where i have to go into data tab and carefully construct a structure to match my SQL.

1) sql widget with some query, no outputs defined : SQL1 structure is not part of suggestions

2) after manually creating a structure to match the output of the sql and setting it as the sql output : this is when SQL1 structure appears as option for the local variable

It will be really helpful, if we write some SQL query on that bases we get automatically suggestion for output structure similar like API response Example .

SQL query Ex.  Select Entity.name, Entity. Surname from Entity 

Then give suggestion of structure with two attribute(name-text, surname-text ) and if we proceed than its created automatically structure

Because right now, if there are 3,4 entity and from that entity we are getting 7,8 attribute record then we need to create structure then pass as output and the process.
So, if this idea will implement then, it will be good to work of such scenario.