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.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/sqlkataquerybuilder.svg)](https://yunodb.com/tools/sqlkataquerybuilder?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/sqlkataquerybuilder?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/sqlkataquerybuilder.svg" alt="Featured on YunoDB" height="20"></a>