Skip to content
← SQL Prompt

How can we improve SQL Prompt?

'Support formatting sql even if it cannot be validated, as best as possible' has been merged into this idea

SQL Prompt: Format SQL

Categories

Allow Format SQL to execute even when there are errors

If I'm halfway through writing a query and I want SQL prompt to format it in order to make it easier to finish what I'm doing, SQL prompt currently will fail because the query's not syntactically correct.

What I'd like is an option where I can tell SQL prompt I don't care if the queries I'm formatting are incorrect, just do your best with it and ignore any errors.

43 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  Andrei Rusitoru responded  · 

Unfortunately the way SQL Prompt parses SQL code currently does not allow for formatting when there are errors in the code.

Changing this would be a very large project because extensive changes to the parser would be required.

We are not planning on doing this at this time.

Thanks for your suggestion,
The Prompt Team

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • David Willis commented  ·   ·  Report

    Just wondering has this ever been reconsidered? The inability to format code that has any syntax errors in it is a pretty significant limitation... there may be times we have a mess of code we need to do something with and formatting at least the parts that the parser can understand will help a lot in being able to work with the rest of it. This is a fairly common scenario actually.

  • Simon Collis commented  ·   ·  Report

    I'm really disappointed by this response, as it limits the usefulness of this function severly.

    I appreciate that it would be a large project, but you're badly letting down your customers here.

  • Simon Collis commented  ·   ·  Report

    That's bad news because it really limits the usefulness of SQL Prompt

  • Michael Hotek commented  ·   ·  Report

    I do this all of the time when I want to rip out all of the extraneous square brackets. But, I have to first correct every syntax error within the code before SQL Prompt will allow me to remove square brackets.

  • Jesse commented  ·   ·  Report

    Support formatting sql even if it cannot be validated, as best as possible. Sometimes we need to format the sql so that we can read it just so that we can see what is wrong. Other tools, such as Poor Man's TSQL formatter can do this.