querybuilder
SqlKata Query Builder is a powerful SQL query builder written in C. It is secure, framework-agnostic, and inspired by query builders like Laravel Query Builder and Knex. Key features include an expressive API with clean SQL-like syntax, database-agnostic support for multiple databases through a unified API, ability to build complex queries with nested conditions and subqueries, automatic injection protection, support for joins, includes, conditional queries, and pagination, and optional execution support via the SqlKata.Execution package which integrates with Dapper for running compiled queries. Supported databases include SQL Server, MySQL, PostgreSQL, Oracle, SQLite, and Firebird. Typical use cases include dynamically constructing queries in .NET applications, preventing SQL injection in user-driven searches and filters, building complex reports with joins and nested conditions, executing compiled queries through Dapper, and managing paginated result sets. Installation is done via NuGet with dotnet add pack