{"repo":"sqlkata/querybuilder","free":true,"listed":false,"github":"https://github.com/sqlkata/querybuilder","clone":"git clone https://github.com/sqlkata/querybuilder.git","description":"SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird","language":"C#","stars":3378,"topics":["sql-query-builder","sql-server","postgresql","mysql","c-sharp","database","query-builder","sql-query","sql","csharp"],"license":"MIT","category":"databases-storage","readme_excerpt":"SqlKata Query Builder Follow and Upvote SqlKata on Product Hunt to encourage the development of this project https://private-user-images.githubusercontent.com/2517523/408899411-1f9ff89b-ed17-4d02-ae2f-afc1c66a5932.mp4 🚀 Introduction SqlKata Query Builder is a powerful SQL query builder written in C#. It is secure, framework-agnostic, and inspired by top query builders like Laravel Query Builder and Knex. ✨ Key Features - Expressive API : Clean and intuitive syntax similar to SQL. - Database Agnostic : Work with multiple databases using a unified API. - Complex Queries : Supports nested conditions, subqueries, conditional statements, and more. - Execution Support : Use the SqlKata.Execution package to execute queries with Dapper. Installation Quick Examples Setup Connection QueryFactory is provided by the SqlKata.Execution package. Retrieve all records Retrieve published books only Retrieve one book Retrieve recent books: last 10 Include Author information This will include the property \"Author\" on each \"Book\": Join with authors table Conditional queries Pagination Insert Update Delete FAQ How to know when a new release or a feature is available? I announce updates on my Twitter Account, and you can subscribe to our newsletters from the website https://sqlkata.com. The database that I want is not supported. Why? It's impossible to support all available database vendors, which is why we focus on the major ones. We encourage you to create your own compiler for your database. Do","default_branch":null,"files":null,"tree":[],"storefront":"/r/sqlkata","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sqlkata/querybuilder/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}