querybuilder
https://github.com/sqlkata/querybuilder
C#
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Triage Issues!
When you volunteer to triage issues, you'll receive an email each day with a link to an open issue that needs help in this project. You'll also receive instructions on how to triage issues.
Triage Docs!
Receive a documented method or class from your favorite GitHub repos in your inbox every day. If you're really pro, receive undocumented methods or classes and supercharge your commit history.
C# not yet supported28 Subscribers
Add a CodeTriage badge to querybuilder
Help out
- Issues
- Support `SelectDatePart`, `GroupByDatePart`, `OrderByDatePart`
- Fix for issue #592, json query fix when question mark is used in data
- Aggregate functions condition support added to Having Queries
- How to do "SELECT EXISTS(SELECT 1 FROM ...)"?
- [Breaking Change] string WhereX methods should not use the LOWER method by default
- CommandType
- SqlResult Overrides
- Fix unit test to run sucessfully on machines with non english locales
- Complex update statement? - UPDATE [Table1] SET [Column] = [Table2.ValueColumn] WHERE [Table1.ID] = [Table2.ID]
- Allow quoting identifiers
- Docs
- C# not yet supported