sqlkata/querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird observed · 2026-08-28
Health v2 · maintenance only
68/100
- Activity 76
- Release rhythm 40
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: 0
- age_days: 3404
- days_rel: 578
- days_push: 145
- n_releases_24m: 2
Adoption not part of the score
3379 stars · 523 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
SqlKata is a fluent SQL query builder library for C#/.NET that compiles expressive queries for SqlServer, MySQL, PostgreSQL, Oracle, SQLite, and Firebird. It uses parameter binding to prevent SQL injection and offers an optional Execution package with Dapper for running queries.
Use cases
- build dynamic sql queries in c#
- write database-agnostic queries across sql server and postgres
- prevent sql injection with parameter binding
- compose complex queries with joins and subqueries in dotnet
- execute queries with dapper in .net
- build a data access layer without a full orm
When to choose
- you want a lightweight alternative to full ORMs like Entity Framework
- you need to target multiple database vendors with one query API
- you prefer writing SQL-like fluent code with full control over the query
- you need safe parameterized queries without manual string building
When to avoid
- you want automatic migrations, change tracking, or entity mapping from schema
- your project is not on the .NET platform
- you need a NoSQL or ORM-style repository abstraction
Facets
library · maturity stable
database orm database-driver databases backend web-development developer-tools dotnet cross-platform sql-query-builder query-builder csharp sql-injection-protection multi-database dapper fluent-api data-access-layer
4 sources
- readme: https://github.com/sqlkata/querybuilder · fetched 2026-08-28 · 231cfaf83309
- homepage: https://sqlkata.com · fetched 2026-08-29 · b4dac43c5d33
- site_page: https://sqlkata.com/docs · fetched 2026-08-29 · be771bb53c61
- site_page: https://sqlkata.com/release · fetched 2026-08-29 · 82e66c30124e
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| sqlkata/querybuilder | main | 68 |
For agents
markdown · JSON · MCP: product_card(name="sqlkata/querybuilder")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem