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
When we have fields of type Date, the **SqlKata.Compile()** converts it to the format "**YYYY-DD-MM**" instead of "**YYYY-MM-DD**", depending on the configuration of your DB, this causes an error when...
I have 2 databases that I am working with, and I need to update data in DB1 from the data residing in DB2. My current method I've been using (prior...
Not an issue, but wondering what's the plan for releasing the enhancements included so far in the main branch? I saw you mentioned #479 that it's twice a year.. is...
Why in the WhereExists method there is a line of code that remove the select component and apply always a 1 costant? https://github.com/sqlkata/querybuilder/blob/be679a9e4db51c0aeec6e8dddd2d377eec76f321/QueryBuilder/Base.Where.cs#L541-L545 I'm using SqlServer and I need to...
I'm running this through some unit tests to play around with it while building myself a compiler to work with an AccessDB, and introduce the 'ALIKE' keyword to be in...
I am trying to generate the following query: ```sql INSERT INTO "tree_prototype" ("name", "height") SELECT 'Accacia 13.8m', 13.78331 WHERE NOT EXISTS(SELECT 1 FROM "tree_prototype" WHERE "name" = 'Accacia 13.8m') ```...
E.g. like in Laravel: https://laravel.com/docs/8.x/pagination#cursor-pagination This would allow pagination in environments where the values are changing quickly. I think one of the maintainers is familiar with Laravel. Therefore I would...
While the changes in #552 solved the issue with timeouts on update and delete operations, it also relies on the existance of a QueryFactory. Unfortunately the QueryFactory is not set...
 Like that
It would be great if the 'Where' could also format user input for full text search in SQL server.
