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 you have a query with a Common Table Expression the query.AsCount().Get() function will return "Invalid object name 'cte0'." When I print the SQL of query.AsCount() the WITH block is...
I have used SqlKata's `[Key]` attribute without the name specified for years without any errors complaining about it, even with `SqlKata.Execution`. However [CsvHelper](https://joshclose.github.io/CsvHelper) seems to be not happy with these...
```csharp var db = new QueryFactory(); var compiler = new PostgresCompiler(); var query = db.Query() .Select("id") .From("table") .Include("public", db.Query(), "foreign_id_1", "local_id_1"); // query.Includes.First().Name => "public" // query.Includes.Count => 1 var...
Is SqlKata.Core AOT ready? I am getting trimming/AOT warnings with it. Is there any chance they can be addressed, since AOT becomes more and more valuable on .NET? 
Hi first thank you for working on this project ! Highly usable and nice API. As mentioned in #666, ideally one would want to support true sql named binding. This...
We just noticed, that SQLKata main classes like QueryFactory ```public class QueryFactory : IDisposable``` are not friendly for unit testing. Is there a reason for that?
It would be helpful to put back the netstandard2.0 target, so that projects which do not yet target net8.0 can continue to benefit from bug fixes and new features. The...
Hi Ahmad, We've been using SqlKata in our project, and I’ve started exploring its internals. I thought the compiler part could be improved significantly both for speed and memory usage....
A colleague reported this issue against our data access layer and we noticed that the milliseconds are missing in the SqlKata generated statement. We suspect https://github.com/sqlkata/querybuilder/blob/981f444c9377b635589f92863602411b44b754e4/QueryBuilder/SqlResult.cs#L72-L80 these lines to be...
