SqlKata Query Builder is a powerful Sql Query Builder written in C#.
It's secure and framework agnostic. Inspired by the top Query Builders available, like Laravel Query Builder, and Knex.
SqlKata has an expressive API. it follows a clean naming convention, which is very similar to the SQL syntax.
It makes writing SQL queries easy and funny, with no need to read long pages of documentations.
It provides a level of abstraction over the supported database engines, that allows you to work with multiple databases with the same unified API.
SqlKata supports complex queries, such as nested conditions, selection from SubQuery, filtering over SubQueries, Conditional Statements and others. Currently it has built-in compilers for SqlServer, MySql and PostgreSql.
Checkout the full documentation on https://sqlkata.com