TSQL.Parser 1.1.2

There is a newer version of this package available.
See the version list below for details.
dotnet add package TSQL.Parser --version 1.1.2
NuGet\Install-Package TSQL.Parser -Version 1.1.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<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
#r "nuget: TSQL.Parser, 1.1.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install TSQL.Parser as a Cake Addin
#addin nuget:?package=TSQL.Parser&version=1.1.2

// Install TSQL.Parser as a Cake Tool
#tool nuget:?package=TSQL.Parser&version=1.1.2

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.
Product Compatible and additional computed target framework versions.
.NET Framework net40 is compatible.  net403 was computed.  net45 was computed.  net451 was computed.  net452 was computed.  net46 was computed.  net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

NuGet packages (12)

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

Package Downloads
DatabaseConverter.Core

Convert or translate database objects and data between SqlServer, MySql, Oracle and Postgres.

EmbeddedSQLTester

Package Description

DFEngine.Compilers.TSQL

Package Description

Tree-Sql-Parser

Library for Parsing, Transforming and Translating SQL queries. See GitHub for details https://github.com/alexmacinnes/tree-sql-parser

MockServiceBus

Mocking Azure Service Bus routing

GitHub repositories (4)

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

Repository Stars
serenity-is/Serenity
Business Apps Made Simple with Asp.Net Core MVC / TypeScript
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.
victor-wiki/DatabaseManager
A simple tool for databases : SqlServer, MySql, Oracle, Postgres and SQLite
Version Downloads Last updated
2.6.0 115,507 10/24/2022
2.5.0 34,326 8/18/2022
2.4.0 4,460 7/15/2022
2.3.0 6,785 7/1/2022
2.2.2 987 6/27/2022
2.2.1 2,980 6/6/2022
2.2.0 800 6/5/2022
2.1.0 2,384 5/6/2022
2.0.1 9,454 3/22/2022
2.0.0 1,477 3/11/2022
1.5.3 145,753 8/23/2021
1.5.2 145,476 5/17/2020
1.5.1 1,302 4/25/2020
1.5.0 70,540 4/12/2020
1.4.0 8,827 3/28/2020
1.3.0 47,505 10/27/2019
1.2.8 15,288 8/9/2019
1.2.7 1,628 7/27/2019
1.2.6 42,975 6/9/2019
1.2.5 91,173 1/19/2019
1.2.4 14,325 11/16/2018
1.2.3 2,563 9/21/2018
1.2.2 1,396 9/16/2018
1.2.1 1,419 9/1/2018
1.2.0 1,224 9/1/2018
1.1.2 5,817 7/4/2018
1.1.1 13,301 1/13/2018
1.1.0 71,816 4/10/2017
1.0.0 2,069 4/1/2017

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