SqlBuildingBlocks.Grammars.SQLServer 1.0.0.130

.NET Standard 2.0

dotnet add package SqlBuildingBlocks.Grammars.SQLServer --version 1.0.0.130

NuGet\Install-Package SqlBuildingBlocks.Grammars.SQLServer -Version 1.0.0.130

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.130" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="SqlBuildingBlocks.Grammars.SQLServer" Version="1.0.0.130" />
                    

                            Directory.Packages.props

<PackageReference Include="SqlBuildingBlocks.Grammars.SQLServer" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add SqlBuildingBlocks.Grammars.SQLServer --version 1.0.0.130

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: SqlBuildingBlocks.Grammars.SQLServer, 1.0.0.130"

#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.

#:package SqlBuildingBlocks.Grammars.SQLServer@1.0.0.130

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=SqlBuildingBlocks.Grammars.SQLServer&version=1.0.0.130
                    

                            Install as a Cake Addin

#tool nuget:?package=SqlBuildingBlocks.Grammars.SQLServer&version=1.0.0.130
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

SqlBuildingBlocks

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`
`SqlBuildingBlocks.Grammars.AnsiSQL`
`SqlBuildingBlocks.Grammars.MySQL`
`SqlBuildingBlocks.Grammars.PostgreSQL`
`SqlBuildingBlocks.Grammars.SQLServer`

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. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.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.

.NETStandard 2.0
- SqlBuildingBlocks.Core (>= 1.0.0.130)

NuGet packages (1)

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

Package	Downloads
ServantSoftware.Data.Common Package Description	106.7K

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
1.0.0.130	4,629	3/12/2025
1.0.0.129	179	3/11/2025
1.0.0.128	176	3/11/2025
1.0.0.127	171	3/11/2025
1.0.0.126	428	3/8/2025
1.0.0.125	160	3/8/2025
1.0.0.124	222	3/7/2025
1.0.0.123	228	3/7/2025
1.0.0.122	223	3/6/2025
1.0.0.121	220	3/6/2025
1.0.0.120	220	3/6/2025
1.0.0.119	223	3/6/2025
1.0.0.118	115	3/2/2025
1.0.0.117	112	2/15/2025
1.0.0.116	112	2/15/2025
1.0.0.115	122	2/15/2025
1.0.0.114	119	2/15/2025
1.0.0.113	119	2/14/2025
1.0.0.112	130	2/13/2025
1.0.0.111	127	2/13/2025
1.0.0.110	117	2/11/2025
1.0.0.108	341	1/8/2025
1.0.0.107	112	1/7/2025
1.0.0.106	943	12/17/2024
1.0.0.105	1,914	11/15/2024
1.0.0.104	148	6/30/2024
1.0.0.103	3,976	4/16/2024
1.0.0.102	142	4/15/2024
1.0.0.101	1,480	4/7/2024
1.0.0.99	146	4/3/2024
1.0.0.97	943	3/27/2024
1.0.0.96	438	3/16/2024
1.0.0.94	563	12/20/2023
1.0.0.93	177	11/21/2023
1.0.0.92	176	10/23/2023
1.0.0.91	173	10/22/2023
1.0.0.90	168	10/22/2023
1.0.0.89	176	10/22/2023
1.0.0.88	156	10/22/2023
1.0.0.87	161	10/16/2023
1.0.0.86	152	10/16/2023
1.0.0.85	152	10/16/2023
1.0.0.84	5,546	10/10/2023
1.0.0.83	1,876	9/26/2023
1.0.0.82	153	9/26/2023
1.0.0.81	144	9/26/2023
1.0.0.80	400	9/25/2023
1.0.0.79	477	9/22/2023
1.0.0.78	1,253	9/17/2023
1.0.0.77	1,146	9/14/2023
1.0.0.76	156	9/14/2023
1.0.0.75	176	9/13/2023
1.0.0.74	400	9/12/2023
1.0.0.73	183	9/12/2023
1.0.0.72	167	9/12/2023
1.0.0.71	161	9/12/2023
1.0.0.70	175	9/12/2023
1.0.0.69	179	9/9/2023
1.0.0.68	623	9/8/2023
1.0.0.67	170	9/8/2023
1.0.0.66	186	9/8/2023
1.0.0.65	174	9/8/2023
1.0.0.64	196	9/8/2023
1.0.0.63	187	9/8/2023
1.0.0.62	187	9/5/2023
1.0.0.61	622	9/1/2023
1.0.0.60	170	9/1/2023
1.0.0.58	397	8/31/2023
1.0.0.57	1,225	8/15/2023
1.0.0.56	214	8/14/2023
1.0.0.55	202	8/10/2023
1.0.0.54	209	8/10/2023
1.0.0.53	213	8/6/2023
1.0.0.52	229	8/6/2023
1.0.0.51	226	8/6/2023
1.0.0.50	208	8/6/2023
1.0.0.49	213	8/5/2023
1.0.0.48	196	8/4/2023
1.0.0.47	208	8/4/2023
1.0.0.46	212	8/4/2023
1.0.0.45	232	8/2/2023
1.0.0.44	212	8/2/2023
1.0.0.43	209	8/1/2023
1.0.0.42	202	7/31/2023
1.0.0.41	209	7/30/2023
1.0.0.40	191	7/30/2023
1.0.0.39	193	7/27/2023
1.0.0.38	208	7/25/2023
1.0.0.37	211	7/24/2023
1.0.0.36	208	7/24/2023
1.0.0.35	201	7/23/2023
1.0.0.34	202	7/22/2023
1.0.0.33	199	7/21/2023
1.0.0.32	200	7/19/2023
1.0.0.31	190	7/19/2023
1.0.0.30	208	7/19/2023
1.0.0.29	211	7/19/2023
1.0.0.28	203	7/18/2023
1.0.0.27	195	7/18/2023
1.0.0.26	213	7/18/2023
1.0.0.25	215	7/16/2023
1.0.0.24	225	7/16/2023
1.0.0.23	209	7/15/2023
1.0.0.22	213	7/14/2023
1.0.0.21	218	7/14/2023
1.0.0.20	205	7/14/2023
1.0.0.19	193	7/14/2023
1.0.0.18	190	7/14/2023
1.0.0.17	206	7/14/2023
1.0.0.16	207	7/13/2023
1.0.0.15	207	7/13/2023
1.0.0.14	204	7/12/2023
1.0.0.13	211	7/12/2023
1.0.0.12	192	7/11/2023
1.0.0.11	201	7/11/2023
1.0.0.10	209	7/11/2023
1.0.0.9	210	7/11/2023
1.0.0.8	216	7/11/2023
1.0.0.7	232	7/10/2023
1.0.0.6	227	7/9/2023
1.0.0.5	220	7/8/2023
1.0.0.4	212	7/8/2023
1.0.0.3	255	7/8/2023