querybuilder
querybuilder copied to clipboard
sqlkata
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
I have a RAW sql that would pivot rows as columns and most of these have special characters for instance columns with period or questionmark dont work var query =...
If the database engine supports a delete + join syntax then compile the query, if not, throw an exception. - [x] SqlServer - [ ] MySql - [ ] PostgreSQL...
Hello. I have a use case where I have to generate select query with offset bigger that `int.MaxValue`. As said in https://github.com/sqlkata/querybuilder/issues/298 `int` is sufficient for almost all cases, but...
Currently, all the methods in the `Query` class return an instance of `Query`. At the project we are working on, we have a `ModelQuery` that have useful methods for retrieving...
Is the `INTO OUTFILE` feature currently supported? I could not find this from the current documentation. What I want to do is like: ```mysql SELECT * INTO OUTFILE 'c:/some-folder/users-2022-02-10.csv' FIELDS...
While working around some issues within the Postgres compiler (like not supporting some operations required to query arrays and JSON) I discovered some issues which can be worked around right...
In SQL we can add a `FILTER` clause to an aggregate `SELECT` clause, i.e. ```sql SELECT [item], SUM([price]) AS [total], SUM([price]) FILTER ( WHERE [date] >= '2021-01-01' ) AS [sales2020]...
Hi, thanks for the great package. in V2.3.7 unfortunately sqlite memory and InsertGetIdAsync when passing the DB connection does not return id.  ```c# var source = _builder.CreateNew().Build(); var query...
Hello All, With all the wisdom in the world, I'm locked into a database that has used `.` notation inside table names. for example: `[Domain.Payment]` Note that the DBA has...
Hi, Why create a new QueryFactory when it can be assigned via an XQuery property. ``` internal static QueryFactory CreateQueryFactory(XQuery xQuery) { //I don't understand what is the meaning of...
