community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

SQL syntax highlighting and formatting in SQL Editor

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:

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!

 

32 Comments
Alteryx Partner

@JPoz  : Great news !! Thanks.

Nebula
Nebula

This would be fantastic - it's been a very commonly requested feature, and one that is sorely needed.

 

@JPoz- loads of us are willing to help with ideas or thoughts if you need help!