SQL Tailor

SQL Tailor is an open source parser for Windows that formats SQL queries. It is built in WPF and C# and can convert them in various versions of SQL or in scripts that produce SQL, such as the SqlOM library.

SQL Tailor uses the Microsoft ScriptDOM library to parse the original query. It then provides various translators who undertake to compose the resulting tokens in the desired versions.

It currently provides three translations:

Microsoft T-SQL: comes directly from the ScriptDOM library and formats the query given in T-SQL.

SQL script: the SQL translations of Tailor. Converts the most common queries at MS SQL or MySQL script. The 'unspecified' version is used as a basis for the other translators of this category.

Fluent script: builds the script of the SqlOM library in C #, which if executed generates the given SQL query.

A developer who wants a different version of SQL can build a new translator without having to start from scratch. He may also use only the SQLParser that does the parsing instead of the entire application.

You can download the SQL Tailor here or download the sources from github.com/kritikov/SQLTailor-released.