gprajapati-conga / tsql-parser

Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net

tsql-parser

Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net

Available on Nuget, TSQL.Parser.

Install-Package TSQL.Parser

Current Features

• Full T-SQL token implementation.
• Streaming tokenizer for parsing scripts into tokens.
• Returns tokens of type characters, comments, identifiers, keywords, literals, variables, and operators.
• Handles both single line and multi line comments.
• Select, Insert, Update, Delete, and Merge statement parsers.
• .Net Framework 4.0+ and .Net Core 2.0+ compatible.

Code Samples

• See wiki for simple code examples and output.
• See test cases in project.

Class Documentation

• bruce-dunwiddie.github.io/tsql-parser/

Some Possible Current Uses

• Colorization
• Dependency Parsing
• Parsing comments.
• Find and replace.
• Script validation.

Future Additions

• More statement parsers built on top of tokenizer.