sqlkata/

querybuilder

SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql and Firebird

Owners:

$90.00

USD raised

Recent activities

ahmad-moussawi was rewarded for sqlkata/querybuilder# 33

almost 6 years ago

ahmad-moussawi submitted an output to sqlkata/ querybuilder# 33

almost 6 years ago

issuehuntfest funded $ 30.00 for sqlkata/querybuilder# 33

almost 6 years ago

ahmad-moussawi submitted an output to sqlkata/ querybuilder# 65

about 6 years ago

edokan submitted an output to sqlkata/ querybuilder# 50

about 6 years ago

Issues

Funded Unfunded Rewarded Closed

Is project still active ?

Unfunded#733created bym4ss1m0g

$0.00

AsInsert doesn't work if value count is different than column count

Unfunded#731created byccambier

$0.00

How to generate tuple matching query based on multiple column?

Unfunded#730created bymd-redwan-hossain

$0.00

Method .As("T") not working?

Unfunded#724created byTiepHoangDev

$0.00

Next release, 3.0.0 from 2022 year is still beta.

Unfunded#723created byKrzysztof318

$0.00

[Ignore] atbt discerning Insert/Update

Unfunded#721created by7CMiguel

$0.00

Use RetryProvider in SqlKata.Execution

Unfunded#718created byGenmutant

$0.00

Postgres over-escaping ?

Unfunded#715created byrolivares

$0.00

Error when trying to insert into Always Encrypted column

Unfunded#711created byAndrew-cqsb

$0.00

Question: Combining multiple Statements

Unfunded#706created byXzelsius

$0.00

how to use include

Unfunded#705created byXxSu

$0.00

FromRaw can't translate list type parameter properly

Unfunded#704created byRevazashvili

$0.00

Vulnerability in System.Text.RegularExpressions 4.3.0

Unfunded#703created byjoehom0416

$0.00

Distinct AsCount error

Unfunded#702created byWimAtIHomer

$0.00

Possible documentation error

Unfunded#701created bynester-a

$0.00

[SQLServer] insert bool value #437

Unfunded#697created bymvernikUt

$0.00

AI chatbot for your documentation

Unfunded#692created byalexsamo1

$0.00

Compile query with parameters for ODBC Connection

Unfunded#691created bymconca-kube

$0.00

RobiniaDocs API Explorer

Unfunded#690created byNeuroXiq

$0.00

Can you please include https://github.com/sqlkata/querybuilder/commit/f3d7c924f4d11c33056d7b002f9d5066dc856117 & re-publish 2.4.0 ?

Unfunded#686created byElderOrb

$0.00

Oracle connection pooling with SqlKata

Unfunded#685created bygalarlo

$0.00

Vulnerability in System.Private.Uri as result of dependency on System.Collections.Concurrent/4.3.0

Unfunded#684created byAnyFlippingUsernameWillDo

$0.00

Meilisearch target?

Unfunded#683created bychucker

$0.00

How can I do SELECT FOR UPDATE ?

Unfunded#678created bymarakonec

$0.00

Escape problem on insert (MySQL)

Unfunded#677created by0x25CBFC4F

$0.00

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

Unfunded#676created byKrishna-Maiden

$0.00

Should PostgresCompiler quote identifiers by default?

Unfunded#671created bymbcrawfo

$0.00

Multiple bindings with the same value

Unfunded#666created byfairking

$0.00

Insert many with IEnumerable<object>

Unfunded#665created byShepardeon

$0.00

Supporting multi-row inserts with IEnumerable<IEnumerable<KeyValuePair<string, object>>>

Unfunded#663created bylilacse

$0.00

Oracle Error ORA-00933 (SQL command not properly ended) on insert of many entities

Unfunded#662created byNunzioCar

$0.00

Example of GetMultiple(Async) method on QueryFactory

Unfunded#661created bym4ss1m0g

$0.00

Sqlite Compiler wraps columns into string literals, preventing the 'No Such Column' exception from occurring (returning the string literal instead of throwing)

Unfunded#655created byRFBomb

$0.00

[Feature request] Insert ignore in mysql, on conflict do nothing postgresql

Unfunded#654created byaskovpen

$0.00

Disposing QueryFactory dispose also my connection

Unfunded#650created byTinmarCyfar

$0.00

Any plans to introduce compiler for in-memory data?

Unfunded#649created bynikhilsarvaiye

$0.00

Support for PostgreSQL 15 "Merge"

Unfunded#644created byspiralw

$0.00

2.4.0 DISTINCT FirstOrDefault without Order By defined adds wrong Order BY statement - SqlServerCompiler

Unfunded#643created bynielslucas

$0.00

How can i do "InsertOrReplace" in sqlite

Unfunded#641created byH0nok4

$0.00

incorrect SQL generated by compilers when using update/insert/delete as a CTE

Unfunded#640created byianclegg

$0.00

Update with Joins

Unfunded#637created bySeanLawless

$0.00

SqliteCompiler - Issue when using Unique Identifier

Unfunded#635created bykapilbhavsar

$0.00

Will it support `SelectDatePart()`, `GroupByDatePart()`, `OrderByDatePart()` in the feature?

Unfunded#631created byCricle

$0.00

How to do "SELECT EXISTS(SELECT 1 FROM ...)"?

Unfunded#619created byBobsans

$0.00

[Breaking Change] string WhereX methods should not use the LOWER method by default

Unfunded#610created byahmad-moussawi

$0.00

Complex update statement? - UPDATE [Table1] SET [Column] = [Table2.ValueColumn] WHERE [Table1.ID] = [Table2.ID]

Unfunded#589created byRFBomb

$0.00

Insert query with WhereNotExist clause (insert or ignore)

Unfunded#579created bySwahhillie

$0.00

How to deal with C# records' EqualityContract property?

Unfunded#573created byzelenij

$0.00

Can support explain?

Unfunded#571created byCricle

$0.00

Full text search for SQL server?

Unfunded#567created bymartoiu

$0.00

Allow setting a bounds on AsIncrement / AsDecrement

Unfunded#565created bymattbrailsford

$0.00

Updated example for Includes

Unfunded#564created byReddevildragg

$0.00

Is SqlServerCompiler thread-safe?

Unfunded#562created bypmarflee

$0.00

Minor improvements required to build and/or extend and/or modify Compilers

Unfunded#537created bymindcrash

$0.00

[Feature Request] Cursor based Pagination

Unfunded#535created byWulfheart

$0.00

CteFinder currently does not support set operations

Unfunded#534created bymindcrash

$0.00

use "on conflict" in postgres

Unfunded#527created byspiralw

$0.00

SqlKata.Execution Paginate Count with multiple column / distinct issue

Unfunded#526created byEcoleKeine

$0.00

Add ability to extend Query class

Unfunded#523created byjhm-ciberman

$0.00

Could you make the Playground editor height bigger?

Unfunded#519created bymoishyr

$0.00

Oracle Error ORA-00904: "TRUE": invalid identifier

Unfunded#517created byfairking

$0.00

How to export comments in the generated query

Unfunded#513created bymnsrulz

$0.00

Attribute map not working

Unfunded#508created byhengway

$0.00

Upstreaming improvements

Unfunded#492created bydgeelen-uipath

$0.00

Add Async version of insert multiple rows

Unfunded#481created byNoamWe

$0.00

How to Perform RawJoin?

Unfunded#475created byGregWilliamBryant

$0.00

TableAttribute introduction

Unfunded#469created byfairking

$0.00

Does the extension method InsertGetId works for Oracle?

Unfunded#465created byfrenkhub

$0.00

Error in test suite

Unfunded#463created bymconca-kube

$0.00

[Table] with nolock for each join tables

Unfunded#462created byBalajiDharmaraj

$0.00

Escaping ? doesn't work

Unfunded#461created bySitharaNA

$0.00

SQL Server use FOR FOR JSON AUTO`

Unfunded#459created byStephaneMartignier

$0.00

[SQL Server] Error inserting varbinary(max) with NULL value

Unfunded#458created bydanehnert

$0.00

Mapping query result to Property of certain type

Unfunded#444created byMardallas

$0.00

Recursive CTE required "WITH RECURSIVE" in postgres

Unfunded#441created byteomane

$0.00

Question mark in 'Like' statements

Unfunded#436created byoleksandr-sidenko

$0.00

Add strong name to QueryBuilder

Unfunded#434created bypetertirrell

$0.00

Can you do TEST for current "Include" or "IncludeMany"

Unfunded#433created bychrisgate

$0.00

How to use join with like automapping?

Unfunded#424created byrobbelroot

$0.00

Add option of WITH (NOLOCK)

Unfunded#420created byShurpop

$0.00

postgres last inserted id : "RETURNING id" vs "lastval()"

Unfunded#401created byjalil1408

$0.00

Feature Request - Multi-level Include & Include Many

Unfunded#395created byflashprogram

$0.00

How to join to CONTAINSTABLE? Do we need JoinRaw?

Unfunded#375created bymrfoster

$0.00

Add date truncation support

Unfunded#357created bySonicGD

$0.00

Support for selecting from an ad-hoc table with parameterized data?

Unfunded#152created byfreakingawesome

$0.00

Compiler for Oracle queries

Unfunded#56created byjonslo

$0.00

Delete statements with joins not supported

Unfunded#16created byceastwood

$0.00

Recent activities

ahmad-moussawi was rewarded for sqlkata/querybuilder# 33

almost 6 years ago

ahmad-moussawi submitted an output to sqlkata/ querybuilder# 33

almost 6 years ago

issuehuntfest funded $ 30.00 for sqlkata/querybuilder# 33

almost 6 years ago

ahmad-moussawi submitted an output to sqlkata/ querybuilder# 65

about 6 years ago

edokan submitted an output to sqlkata/ querybuilder# 50

about 6 years ago

querybuilder

$90.00

Issues

Company

Community

Support

Connect