querybuilder

querybuilder copied to clipboard

Disposing QueryFactory dispose also my connection

1

When i dispose Queryfactory, il also dispose my connection (i use this connection in diffèrent other process) Proposition : Delete this code ? (its not the role of sqlkata to...

TinmarCyfar

Bumps [Newtonsoft.Json](https://github.com/JamesNK/Newtonsoft.Json) from 11.0.2 to 13.0.2. Release notes Sourced from Newtonsoft.Json's releases. 13.0.2 New feature - Add support for DateOnly and TimeOnly New feature - Add UnixDateTimeConverter.AllowPreEpoch property New feature...

dependabot[bot]

Replace data if has same key,or insert a new Key-Value.

H0nok4

Wrong binding OrderByRaw with type of array

2

I'm try this query with playground. Array variable only get first index and variables after it use value of array. Query ``` using SqlKata.Extensions; var test1 = "test1"; var test2...

kenzouno1

It appears SqlKata is unable to generate 'data-modifying' common table expressions (CTE's). This can be observed when using the fluent api to build a Query using the `With` method and...

ianclegg

Select * INTO x from Y

3

Can we have a statement that allows us to insert into a temp table using the sql standard INTO? All other statements seem to be available but this, and hand-coding...

jimsandersonuk

Hi, Just wondering if it is possible to build a query statement to update a table which includes joins. When using the Update() method it compiles fine but does not...

SeanLawless

SqliteCompiler - Issue when using Unique Identifier

1

The query generated by SqliteCompiler for a table with UUID, the parameters are treated as string. But the sqlite db stores UUID as blob so the strings needs to be...

kapilbhavsar

Support `SelectDatePart`, `GroupByDatePart`, `OrderByDatePart`

1

- [x] SelectDatePart - [x] GroupByDatePart - [x] OrderByDatePart

Cricle

From https://sqlkata.com/docs/where-date#wheredate support where datepart. Will it support in the feature?

Cricle