SQL Parser in C#, using .NET 3.5.
The intention of this project is to implement a 'pretty formatter' of SQL for several reasons - one, due to the terse nature of NHibernate generated SQL, and also
... [More]
in general to ensure sql is readable (according to my standard).
There is a simple one page sql formatter available here to allow some experimentation, but this project is still in its infancy, so don't expect too much just yet!
Current Features
Supports SELECT, INSERT, UPDATE, DELETE, DECLARE, GO statements Uses white space liberally to separate table and join parts MSI for an addin into MS Management Studio 2008 to allow formatting and template expansion NHibernate Appender to asynchronously format all NHibernate.SQL originated log messages Simple web page to allow adhoc SQL formatting Plans for future updates:
Fix all reported bugs Implement more formatting output for INSERT statement Implement formatter for CREATE TABLE, ALTER TABLE, CREATE INDEX, etc. Implement CREATE/ALTER PROCEDURE Implement SELECT UNION (I should have done this earlier, but I kept delaying it!) [Less]