querybuilder

querybuilder copied to clipboard

I'm not sure how feasible this is, given that Meilisearch's [query language isn't quite SQL](https://www.meilisearch.com/docs/learn/fine_tuning_results/filtering#filter-operators), but [the examples](https://sqlkata.com) on the front page look a lot like things that could be...

chucker

Any plans to introduce compiler for in-memory data?

5

Any plans to introduce compiler for in-memory data in lists, collections? which can be useful in case of caching like Redis, or for general code performance. I would love to...

nikhilsarvaiye

Feature/add create table

1

hi. in this commit i add support for create table query for mysql,postgresql,oracle,sqlserver and sqlite dbs. i add support for identity and auto increment and primary key and unique constraint....

AlirezaEiji191379

SELECT INTO Statement

2

Requesting support for SELECT INTO Statement. https://www.w3schools.com/sql/sql_select_into.asp Thanks

suhrab

Issue in SQL Server - Unable to set null value to column in db

4

I have tried setting the null value like below map[keyValuePair.Key] = DBNull.Value; but I am receiving exception 'The member p3 of type System.DBNull cannot be used as a parameter value'...

Krishna-Maiden

Hello. What do I need to do to get a sql with SELECT FOR UPDATE? I understand that I can use a sql statement in this case, but is there...

marakonec

Version: 2.3.7 (also tested on 2.4.0) When inserting escaped JSON string SqlKata generates incorrect SQL: ```sql INSERT INTO `Table` (`field`) VALUES ('{"Name":"\u111B"}') ON DUPLICATE KEY UPDATE someField=null; ``` Which results...

0x25CBFC4F

Should PostgresCompiler quote identifiers by default?

1

Throwing this out as a discussion topic because as far as I can find it hasn't been mentioned before. A quirk of PostgreSQL is that quoting identifiers affects the behavior...

mbcrawfo

Multiple bindings with the same value

2

I am trying to get some query working which includes binding value multiple times: eg. ``` c# .OrderByRaw("CASE WHEN StartDate < ? and (EndDate is null or EndDate > ?)...

fairking

sergemso