For the list of known issues, please see the issue tracker on github. The library is largely complete, but undocumented. It does not distinguish between different types of DML, it does not parse full expression trees, etc - there's a lot it doesn't do, it just does the bare minimum to support the target formatting. This formatter does implement a high-level SQL tokenizer and parser, but the granularity of the parser is not very high. What if I want my SQL formatted differently? Your Formatting preferences? Who are you? Written in C# using a pluggable design that should allow for other SQL dialects to be supported in future.Net 2.0/3.5 library, downloadable here or through NuGet JS library that exposes the same functionality in any browser or other Javascript-based context, used in the demo/online formatting site.WinMerge plugin, for automatically formatting SQL files before comparison, allowing WinMerge to display content changes only, ignoring formatting differences.Winforms app for easy offline formatting (also lets you look at the token stream and parse tree).Command-line utility that lets you format any number of files in bulk, or format from some other arbitrary program - for windows (.Net) or any environment (node/npm).Notepad++ plugin, for quick single-key formatting in your favorite general-purpose text editor.SSMS (SQL Server Management Studio) and Visual Studio Addin/Extension that allows you to format the current file or selected text with a single hotkey - supports any version of SSMS or SSMS Express, and any Full (not Express) version of Visual Studio.Available ready-to-use in a variety of forms.Also provides 'minifier' option to strip out comments and whitespace, to obfuscate rather than pretty-print your code.Optionally outputs 'colorized' html code rather than just the formatted SQL.

Provides formatting options to cater to different common formatting styles/standards.

Handles complete multi-batch scripts, including object definition scripts such as stored procedures, triggers, etc.

This is a free and open-source SQL (T-SQL) formatter:

Download notepad++ msi package