querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
What is querybuilder?
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Overview of querybuilder
What it is
SqlKata Query Builder is a SQL query builder written in C#. It is designed to help developers build complex queries easily. The library is framework-agnostic and supports multiple database providers including SqlServer, MySql, PostgreSql, Oracle, Sqlite, and Firebird. It is inspired by query builders such as Laravel Query Builder and Knex.
Key features
- Expressive API with clean and intuitive syntax similar to SQL.
- Database agnostic, allowing work with multiple databases using a unified API.
- Supports complex queries including nested conditions, subqueries, and conditional statements.
- Execution support via the SqlKata.Execution package, which enables query execution with Dapper.
Use cases
SqlKata Query Builder can be used in any .NET application that needs to construct and execute SQL queries programmatically. It is suitable for scenarios requiring dynamic query generation, such as building reports, implementing search filters, or creating data access layers that need to support multiple database backends.
Getting started
Install the package via the .NET CLI:$ dotnet add package SqlKataFor execution support, also install:$ dotnet add package SqlKata.ExecutionFor full setup instructions and examples, see the repository README.
License and pricing
The project is licensed under the MIT license and is open source.
Based on the project's public README and repository metadata.