Embedded REAL SQL query builder and free SQL Query

[simonaubert_bd]

As of today, you can pass SQL from :
-input tool

-output tool

-connect in-db

The user interface is very limited, the kind of query you can pass also, welll, not very user-friendly. This generates a lot of frustration among users.

What do I suggest :
1/ A direct button "Query Builder" without having to open a new wf and drop an input box and then go with the presql tool and fight to build a query.

2/ Basically the same features than Dbeaver (https://dbeaver.io ) or DBvisualizer (https://www.dbvis.com/) or SQUIRREL http://squirrel-sql.sourceforge.net/ 😞
  -Ability to pass any SQL Code I want (such as update, create, truncate, etc...) when I come from the button, "protected" sql when I am in a workflow
  -autocompletion

  -color coding (The idea is not new )

 
3/ A box "Free Sql Query" that I can branch on a indb or standard wf to pass any SQL query. The Output would be the same as input, just like it would be with a block until done.

[simonaubert_bd]

(please note all the tools below are open-source)

[simonaubert_bd]

For reference :

SQL Editor on Talend https://help.talend.com/reader/c_2Som3s_um3RPoWUM_SlQ/pv89bv2UgAhtCoBhtIGpOg

A screenshot from Dataiku with sql color coding:

[SeanAdams]

Hey @simonaubert_bd 

I do agree with you that having a generic SQL tool would be very useful - in fact that was suggested by @chris_love  here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Have-an-SQL-Tool/idi-p/5392

(it's worth you adding your support and comments to that thread)

As to the colour coding - this has been delivered in a later release - the team did a great job of this.

[simonaubert_bd]

Hello @SeanAdams ,

Old idea 😛

I already have commented and adding my support two years ago when I found it.

Best regards,

Simon