SQL syntax highlighting and formatting in SQL Editor

[JohnJPS]

The SQL Editor window could have a better presentation of the SQL code; two issues observed

• First, that it's simply plain text without even a fixed-width font, much less syntax highlighting
• Second, if you type in some manually formatted SQL code (e.g. with line feeds and indentation), then click on the "Visual Query Builder" button, then click back to the "SQL Editor" button, all the formatting is lost as it is converted to one run-on line of code, which is very difficult to read.

I understand that going between the Visual Query Builder and the SQL Editor is bound to have some issues; nonetheless the "idea" is to allow a user friendly display in the SQL Editor window:

• Use a fixed width font, (should be trivial to implement)
• SQL formatter, implementation ideas can be found here: https://github.com/TaoK/PoorMansTSqlFormatter
• SQL syntax highlighting, implementation ideas can be found here: https://github.com/jdorn/sql-formatter

My "implementation ideas" are based on a couple minutes with google, so hopefully this is a very feasible request; my user base is very likely to spend more time in the SQL editor than not, so this would be a valuable UX addition.  Thanks!

[dawid_nawrot]

I would realy like that feature implemented very much! Better syntax highligting would help a lot in many cases

[Aamir]

Yes, yes and hell yes. Me too. Right now I edit my SQL code in Sublime and copy paste it into Alteryx. This is obviously not ideal.

[mark_cyr]

+1

[Atabarezz]

+1

[adrianloong]

+1... Definately an important feature that will be really useful for most users

[ARich]

Hi John,

Thanks for the feedback. We'll look at adding some of these features in a future release.

Best,

Alex

[bkornell1]

+1

[JohnJPS]

One thing that's missing from my product idea is auto-complete.  That takes it to a whole new level, but it would be the holy grail:  Users would be out of excuses to keep using SQL Mgmt Studio.  :-)

[Atabarezz]

I was expecting this in version 11.0 :(

[adrianloong]

Really hope to see this in v11 as its great to use alteryx as a 1 stop shop instead of another sql editor or multiple editors (eg: Oracle, SQl managment studio etc)