Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Should we use Syntax Editor for what we are trying to accomplish?

We are in the process of developing a SQL query editor.  In this editor users will have the ability to write SQL queries using normal SQL syntax. As users construct these queries, they will use the option of using string variables that will be resolved to literal strings prior to submitting the query to be executed.  During the construction process of these SQL queries users may misspell these variables.  We would like to use syntax editor to hightlight these and other SQL syntax errors.


For example, take the SQL syntax below.  For these examples the variables { Variable1, Variable2, Variable3} are valid variables that can be used in a query. Since the first example has the variable typed correctly this is valid.  The second example has a misspelled variable, in these scenario we would like the misspelled variable to be highlighted in some fashion that will bring the user to take action to resolve. Is Syntax editor the best solution to accomplish our desired goal?


Valid Variable List: Variable1, Variable2, Variable3

Valid = Select * from Table where Column = Variable1

Invalid = Select * from Table where Column = Variabl1

  • 25065
    Offline posted

    Hello Andy,

    After investigating this and doing some research, compiling the sql in syntax editor has been determined to be a product idea. You can suggest new product ideas for future versions by submitting here:

    Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case.  You can also link back to this thread for additional details.
    Thank you in advance to submitting your product idea.

    Include a link to this thread in your idea so product management will be able to look back at this forum thread.