SqlBuildingBlocks.Grammars.SQLServer 1.0.0.93

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package SqlBuildingBlocks.Grammars.SQLServer --version 1.0.0.93                

                    
                

            
NuGet\Install-Package SqlBuildingBlocks.Grammars.SQLServer -Version 1.0.0.93
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="SqlBuildingBlocks.Grammars.SQLServer" Version="1.0.0.93" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SqlBuildingBlocks.Grammars.SQLServer --version 1.0.0.93                

                    
                

            
#r "nuget: SqlBuildingBlocks.Grammars.SQLServer, 1.0.0.93"
#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 SqlBuildingBlocks.Grammars.SQLServer as a Cake Addin
#addin nuget:?package=SqlBuildingBlocks.Grammars.SQLServer&version=1.0.0.93

// Install SqlBuildingBlocks.Grammars.SQLServer as a Cake Tool
#tool nuget:?package=SqlBuildingBlocks.Grammars.SQLServer&version=1.0.0.93

SqlBuildingBlocks

Build

Project Status

IMPORTANT NOTE: This project is currently under development and not yet viable for production use. It is a work in progress, and we appreciate your patience, help and/or interest.

Overview

SqlBuildingBlocks is an extensible open-source library, designed to parse SQL into manageable, logical classes tailored to different database technologies. It's built upon Irony's SQLGrammar example and leverages design patterns like Factory and Strategy for customization of SQL parsing, making it an excellent tool for working with SQL across multiple databases.

Project Objectives

  • Extensibility: Cater to various database technologies by providing specialized grammars.
  • Usability: Represent complex SQL grammar in a more manageable, logical, and user-friendly format.
  • Testability: Offer a strong unit-testing framework to ensure the reliability of the code.

How It Works

SqlBuildingBlocks breaks down SQL into fundamental 'building blocks', or NonTerminal classes, each of which can handle a specific part of the SQL language. These NonTerminal classes use a factory pattern to create 'logical' classes that represent the elements of the SQL language.

Future Developments

Our roadmap for SqlBuildingBlocks includes developing custom grammars for popular database technologies such as SQL Server, MySQL and PostgreSQL. Furthermore, we are working on a general all-purpose query engine which is still in its infancy. Stay tuned for these exciting updates!

Contributing

We're open to contributions from the community. Contributions are welcome. Please refer to our contributing guidelines for more information.

License

This project is licensed under the terms of the MIT license. For more information, please see the LICENSE file.

Installation

Install builds via Nuget.

Package Name Release (NuGet)
SqlBuildingBlocks.Core NuGet
SqlBuildingBlocks.Grammars.AnsiSQL NuGet
SqlBuildingBlocks.Grammars.MySQL NuGet
SqlBuildingBlocks.Grammars.PostgreSQL NuGet
SqlBuildingBlocks.Grammars.SQLServer NuGet

Contact

For any inquiries or issues related to SqlBuildingBlocks, please open an issue on GitHub, and we'll do our best to respond promptly.

We're excited to embark on this journey with the community and look forward to seeing SqlBuildingBlocks grow! Stay tuned for more updates as the project progresses.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on SqlBuildingBlocks.Grammars.SQLServer:

Package Downloads
ServantSoftware.Data.Common

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
1.0.0.104 107 6/30/2024
1.0.0.103 1,885 4/16/2024
1.0.0.102 104 4/15/2024
1.0.0.101 1,444 4/7/2024
1.0.0.99 114 4/3/2024
1.0.0.97 907 3/27/2024
1.0.0.96 403 3/16/2024
1.0.0.94 532 12/20/2023
1.0.0.93 156 11/21/2023
1.0.0.92 152 10/23/2023
1.0.0.91 147 10/22/2023
1.0.0.90 139 10/22/2023
1.0.0.89 150 10/22/2023
1.0.0.88 127 10/22/2023
1.0.0.87 134 10/16/2023
1.0.0.86 122 10/16/2023
1.0.0.85 123 10/16/2023
1.0.0.84 5,509 10/10/2023
1.0.0.83 1,841 9/26/2023
1.0.0.82 123 9/26/2023
1.0.0.81 118 9/26/2023
1.0.0.80 373 9/25/2023
1.0.0.79 438 9/22/2023
1.0.0.78 1,217 9/17/2023
1.0.0.77 1,114 9/14/2023
1.0.0.76 127 9/14/2023
1.0.0.75 145 9/13/2023
1.0.0.74 369 9/12/2023
1.0.0.73 153 9/12/2023
1.0.0.72 136 9/12/2023
1.0.0.71 124 9/12/2023
1.0.0.70 145 9/12/2023
1.0.0.69 147 9/9/2023
1.0.0.68 589 9/8/2023
1.0.0.67 136 9/8/2023
1.0.0.66 153 9/8/2023
1.0.0.65 139 9/8/2023
1.0.0.64 163 9/8/2023
1.0.0.63 154 9/8/2023
1.0.0.62 153 9/5/2023
1.0.0.61 587 9/1/2023
1.0.0.60 139 9/1/2023
1.0.0.58 363 8/31/2023
1.0.0.57 1,188 8/15/2023
1.0.0.56 175 8/14/2023
1.0.0.55 166 8/10/2023
1.0.0.54 172 8/10/2023
1.0.0.53 176 8/6/2023
1.0.0.52 191 8/6/2023
1.0.0.51 186 8/6/2023
1.0.0.50 167 8/6/2023
1.0.0.49 175 8/5/2023
1.0.0.48 157 8/4/2023
1.0.0.47 170 8/4/2023
1.0.0.46 175 8/4/2023
1.0.0.45 194 8/2/2023
1.0.0.44 173 8/2/2023
1.0.0.43 168 8/1/2023
1.0.0.42 165 7/31/2023
1.0.0.41 172 7/30/2023
1.0.0.40 154 7/30/2023
1.0.0.39 154 7/27/2023
1.0.0.38 172 7/25/2023
1.0.0.37 173 7/24/2023
1.0.0.36 169 7/24/2023
1.0.0.35 163 7/23/2023
1.0.0.34 165 7/22/2023
1.0.0.33 159 7/21/2023
1.0.0.32 160 7/19/2023
1.0.0.31 152 7/19/2023
1.0.0.30 164 7/19/2023
1.0.0.29 173 7/19/2023
1.0.0.28 163 7/18/2023
1.0.0.27 156 7/18/2023
1.0.0.26 173 7/18/2023
1.0.0.25 177 7/16/2023
1.0.0.24 187 7/16/2023
1.0.0.23 171 7/15/2023
1.0.0.22 175 7/14/2023
1.0.0.21 178 7/14/2023
1.0.0.20 166 7/14/2023
1.0.0.19 153 7/14/2023
1.0.0.18 151 7/14/2023
1.0.0.17 164 7/14/2023
1.0.0.16 170 7/13/2023
1.0.0.15 170 7/13/2023
1.0.0.14 168 7/12/2023
1.0.0.13 168 7/12/2023
1.0.0.12 155 7/11/2023
1.0.0.11 162 7/11/2023
1.0.0.10 169 7/11/2023
1.0.0.9 171 7/11/2023
1.0.0.8 175 7/11/2023
1.0.0.7 192 7/10/2023
1.0.0.6 185 7/9/2023
1.0.0.5 176 7/8/2023
1.0.0.4 169 7/8/2023
1.0.0.3 213 7/8/2023