querybuilder

Offers a clean, SQL-like syntax that makes queries readable and maintainable, as shown in examples with conditional logic and joins that mimic raw SQL structure.

Supports six major databases (SQL Server, PostgreSQL, etc.) with a unified API, enabling code portability and reducing vendor lock-in, as highlighted in the key features.

Handles nested conditions, subqueries, pagination, and joins programmatically, allowing dynamic query construction without string concatenation, demonstrated in the quick examples.

The optional SqlKata.Execution package integrates with Dapper for efficient query execution, combining the builder's expressiveness with Dapper's performance, as noted in the installation section.