TSQL.Parser 1.1.2

Library for Parsing SQL Server T-SQL Scripts

There is a newer version of this package available.
See the version list below for details.
Install-Package TSQL.Parser -Version 1.1.2
dotnet add package TSQL.Parser --version 1.1.2
<PackageReference Include="TSQL.Parser" Version="1.1.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add TSQL.Parser --version 1.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

tsql-parser

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

Source Available on GitHub, TSQL.Parser.

Available on Nuget, TSQL.Parser.

Install-Package TSQL.Parser

Travis

AppVeyor

License

Current Features

  • Full T-SQL 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 statement parser.

Some Possible Current Uses

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

Future Additions

  • More statement parsers built on top of tokenizer.

Code Samples

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

tsql-parser

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

Source Available on GitHub, TSQL.Parser.

Available on Nuget, TSQL.Parser.

Install-Package TSQL.Parser

Travis

AppVeyor

License

Current Features

  • Full T-SQL 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 statement parser.

Some Possible Current Uses

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

Future Additions

  • More statement parsers built on top of tokenizer.

Code Samples

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

Release Notes

Bug fix for common case of empty parenthesis in ROW_NUMBER() usage.

Dependencies

This package has no dependencies.

NuGet packages (7)

Showing the top 5 NuGet packages that depend on TSQL.Parser:

Package Downloads
ETLBox
A lightweight ETL (extract, transform, load) library and data integration toolbox for .NET. Source and destination components let you read and write data from the most common databases and file types. Transformations allow you to you harmonize, filter, aggregate, validate and clean your data.
DFEngine.Compilers.TSQL
Package Description
DatabaseConverter.Core
Convert or translate database objects and data between SqlServer, MySql and Oracle.
TSQL.Color
Library for Colorizing SQL Server T-SQL Scripts
z.ETL
Package Description

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on TSQL.Parser:

Repository Stars
OpenDBDiff/OpenDBDiff
A database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.
Warewolf-ESB/Warewolf
Effortless Microservice Design and Integration. This repository includes the code-base for the Warewolf Studio and Server.
etlbox/etlbox
A lightweight ETL (extract, transform, load) library and data integration toolbox for .NET.

Version History

Version Downloads Last updated
1.5.2 8,305 5/17/2020
1.5.1 439 4/25/2020
1.5.0 10,643 4/12/2020
1.4.0 486 3/28/2020
1.3.0 15,220 10/27/2019
1.2.8 7,010 8/9/2019
1.2.7 398 7/27/2019
1.2.6 12,677 6/9/2019
1.2.5 71,567 1/19/2019
1.2.4 7,501 11/16/2018
1.2.3 806 9/21/2018
1.2.2 471 9/16/2018
1.2.1 344 9/1/2018
1.2.0 283 9/1/2018
1.1.2 3,288 7/4/2018
1.1.1 2,055 1/13/2018
1.1.0 36,840 4/10/2017
1.0.0 690 4/1/2017
Show less