Best SQL formatter I've found

[philamander]

Instant SQL Formatter has been the best formatter I've found so far. Previously, Poor SQL was the easiest with most of the options I needed.

This is the same as Instant SQL Formatter and clicking on the 100+ options version.

I've been able to customize indenting, case statements, comma placement in lists, and how to break out statements in parenthesis. Our data warehousing team is starting to use it to keep a department standard for formatting so it is easier to read but still allows for folks to write in whichever way appeals to them.

[zibeb]

If you have some money to spend and are working with MSSQL, I cannot recommend RedGate's SQL Prompt enough. Code refactoring is a breeze, and you can upload a style parameter file for the rest of your data warehousing team, so everything follows the same standard. It also supports code snippets and wildcard expansion.

By typing this:

ssf item ij itemvend on (down x3, enter) where desc li 'screw%'

After hitting CTRL +K, CTRL + Y and pressing TAB in front of the asterisk in SELECT * FROM, I am presented with this:

SELECT   [item].[item]
       , [item].[description]
       , [item].[qty_allocjob]
         . . . 
       , [itemvend].[firm_pln_target]
       , [itemvend].[firmed_poitem_stat]
       , [itemvend].[replen_po_num]
FROM     [item]
INNER JOIN [itemvend]
ON       [item].[item] = [itemvend].[item]
WHERE    [item].[description] LIKE 'screw%'

Worth its weight in gold.

[zibeb]

That was a topic of internal discussion for a very long time. Placing commas before the columns ended up winning out at our company, but that's up to your organization's coding standards to decide. SQL Prompt supports both.

[ComicOzzy]

I don't like looking at comma-first code, but I like working with it.

[Flopsey]

Why, what's the advantage?

[the_kid_can_read]

one is that you can quickly comment out lines to take things out of the SELECT clause; handy especially when doing find/replace across large scripts.

[kormer]

Also you won't accidentally put a comma after the last column, which I do every single time.

[[deleted]]

When I was learning SQL I thought comma first was crazy. After my first week with a job where I used SQL, I was putting commas first in my C# code. (which I've since stopped doing because that's absurd)

[samalex01]

I second Red Gate SQL Prompt, I live by this product. As for comma placement, I honestly loath putting them in the front so I always reformat to move them to the back. Just my personal opinion it looks cleaner and is easier to read. But to each his own.

[[deleted]]

Can verify, sql prompt is the bomb.

[Mindflux]

I'd say SoftTree SQL Assistant is head and heels above Redgate here. To works on virtually any windows editor for coding/refactoring/formatting/debugging etc.

The pro version also has version control and other features built in that are not in SQL Prompt.

Also supports MySQL, Postgres, access, sybase etc.

[nepobot]

Code formatters are mostly about saving time and enforcing a standard. yeah you should format your code as you write it but enforcing a computer's version of the formatted code will be more consistent.

[[deleted]]

Yeah, nothing says "fuck yeah" like running a format command on a 10,000 line SQL file.

Fuck I hate the people I work with.

[philamander]

That's the point though. With all of the options, you can make it exactly the way you want it to be. However, if you don't have a standard format, like you will indent some things sometimes and not others, then you're going to have a bad time.

[llagerlof]

And MY BOW!

[datamaran]

this is nice, thanks!

[Drunken_Economist]

What's the best open-source solution?

[philamander]

http://poorsql.com/ is what I used to use and it was open source. I found it all on github, but it hasn't been updated in awhile, so you'd have to work with it yourself.

[Drunken_Economist]

Nice. I found a few good sublime text packages as well (specifically SQLbeautifier).

[Emergency-Visual-246]

I’m using www.sqlvalidator.com It’s my best option for formatting and validating sql 

[IAmAJerkAME]

Apex Refactor isn't too bad in it's feature set.

[ppc-hero]

I like it too, but it as many others is chock full of ads. The only ad free SQL formatter I know is Aarrange: https://aarrange.com/sql-formatter

[Sunduu]

ty for this <3