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

over 5 years ago

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

over 5 years ago

issuehuntfest funded $ 30.00 for sqlkata/querybuilder# 33

over 5 years ago

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

over 5 years ago

edokan submitted an output to sqlkata/ querybuilder# 50

over 5 years ago

Issues

Funded Unfunded Rewarded Closed

Transactions not being passed to dapper

Funded#113created byrmedcalf

$10.00

HAVING clause with COUNT(*) not generating correct sql

Unfunded#387created bydions

$0.00

Problems with Insert name of variables

Unfunded#388created byneiesc

$0.00

How can I get resultset from stored procedure?

Unfunded#389created bymgh9

$0.00

SqlServerCompiler compiling AsInsert with @p1 @p2 instead of real values

Unfunded#367created byg33kz0rd

$0.00

Defined variables are replaced in Sql

Unfunded#384created byvvopenka

$0.00

Using Raw Literals in Update

Unfunded#354created byarakis

$0.00

Version greater than 1.1.7 marked as prerelease in Nuget

Unfunded#348created byb-twis

$0.00

Rename generated DLL to SqlKata.dll instead of QueryBuilder.dll

Unfunded#109created byjohnny551

$0.00

Unique alias generator

Unfunded#118created bytlaguz

$0.00

Possible to get Slightly Better Formatting?

Unfunded#129created bylilasquared

$0.00

OUTPUT/RETURNING Clause Support for Inserts/Updates/Deletes

Unfunded#133created byfreakingawesome

$0.00

Review overall culture-specific issues

Unfunded#225created byceastwood

$0.00

Should we change ToUpper-ToLower methods as ToUpperInvariant-ToLowerInvariant methods

Unfunded#281created bykucukf

$0.00

QueryTimeout is always overwritten in the QueryHelper.CreateQueryFactory

Unfunded#345created byMostafa-Elmoghazi

$0.00

SqlKata.Executable and QueryFactory after installing SqlKata 1.1.7 using NuGet

Unfunded#366created bypaultipper

$0.00

Lack of Connection Dispose in documentation

Unfunded#213created byjoshcobalt

$0.00

Naming strategy with ORACLE

Unfunded#391created byfairking

$0.00

SqlServerCompiler removing 'GROUP BY' clause after Compile()

Unfunded#330created bymark-at-tusksoft

$0.00

System.Missing Method Exception

Unfunded#392created byaustinwilcox1

$0.00

QueryFactoryExtensionsAsync isn't in 1.1.7.0 assembly

Unfunded#352created bybenmccallum

$0.00

Using COUNT in Select

Unfunded#359created byfairking

$0.00

Limit/Offset alters select statement by adding row_num

Unfunded#340created bymark-at-tusksoft

$0.00

Consider next extensions

Unfunded#393created bydzmitry-lahoda

$0.00

Creating a base model

Unfunded#394created bynetbounty

$0.00

Where with bool or bool? is compiled as "true" or "false" rather than "0" or "1"

Unfunded#396created bybenmccallum

$0.00

UUID_TO_BIN(UUID()) as value when inserting a record

Unfunded#397created byansarizafar

$0.00

How to concatenate strings with sqlkata?

Unfunded#399created byjeansusgodney

$0.00

Сompiling large queries takes a long time

Unfunded#402created byalex-tselikovsky

$0.00

Case insensitive like/startswith using `Lower` by default

Unfunded#403created byrondelward-pf

$0.00

Query assignments with side effects

Unfunded#404created bybrgrz

$0.00

QUERY UPDATE WITH INNER JOIN [MYSQL]

Unfunded#405created bysrburton

$0.00

join support for delete statements

Unfunded#182created byceastwood

$0.00

Incorrect parcing double in Insert and Update

Unfunded#406created byBakharevAlexander

$0.00

curly brackets being replaced by square brackets

Unfunded#407created bythedarkvessle

$0.00

Suggest Splitting into multiple projects

Unfunded#408created byabbasmhd

$0.00

Use Where DateTime without miliseconds

Unfunded#409created byShurpop

$0.00

Missing Method Exception

Unfunded#410created bymadben2000

$0.00

Join support for Lateral jsonb_array_elements() in postgres

Unfunded#411created byVenkateshRathinavel

$0.00

[SQLInjection] SelectRaw, Select

Unfunded#414created bysrburton

$0.00

WHERE values come up as @p0, @p1 etc. in every query (in Unity)

Unfunded#416created byMaxwellDexter

$0.00

Support full outer join

Unfunded#417created bymabdelaal86

$0.00

Row as Dictionary<string, object> via GetDictionaryAsync

Unfunded#418created bypavelvondrasek

$0.00

WhereDate has some weird behaviour

Unfunded#422created byfairking

$0.00

Use column name for parameters instead of @p0 , @p1

Unfunded#423created bymnns

$0.00

Column name like 'Qty as Litre' is treated alias name

Unfunded#427created byjaiganeshs

$0.00

.vscode/tasks.json

Unfunded#428created byAreefh

$0.00

Curly Brackets compiled into Square Brackets: Request to disable column identifier

Unfunded#430created byEyreC

$0.00

Unfunded#431created byksokolowski7

$0.00

aspnet core di container error

Unfunded#432created bygodshades

$0.00

SqlKata's Humanizer.Core version is incompatible with later versions (affecting compatibility with .NET 5 EF and other assemblies)

Unfunded#435created byjwstadler

$0.00

[SQLServer] insert bool value

Unfunded#437created bystefaniaolivares

$0.00

AsMax when result is NULL

Unfunded#439created byJordiPerello

$0.00

WhereConains fails when when object is guid and contains {}

Unfunded#440created bysrenrd

$0.00

Firebird token unknown error

Unfunded#445created bye-belair

$0.00

Insert async method overload with only column and data values

Unfunded#446created bysafayatzisan

$0.00

Calling SelectRaw and passing in an empty string results in an extra trailing comma at the end of the SELECT right before the FROM

Unfunded#447created byjspinella

$0.00

Make all Compiler Compile methods protected virtual

Unfunded#449created byb-twis

$0.00

JOIN on Query

Unfunded#451created byyankyhgoflow

$0.00

Multiple Or condition

Unfunded#452created bygodshades

$0.00

With (NOLOCK) on joining table.

Unfunded#229created byMadOnProgramming

$0.00

SemVer?

Unfunded#322created bySharparam

$0.00

The member p3 of type SqlKata.InsertClause cannot be used as a parameter value

Unfunded#365created byHiggs2

$0.00

Nested having doesn't work

Unfunded#360created bySonicGD

$0.00

SQL syntax error while using Limit with UnionAll in MySQL

Unfunded#454created bySanjay85500

$0.00

'last_insert_rowid' is not a recognized built-in function name.

Unfunded#455created bylesair

$0.00

Incorrect syntax near 'LIMIT'

Unfunded#456created bylesair

$0.00

ColumnAttribute is not mapping columns to strong type property.

Unfunded#457created bylesair

$0.00

Include And Define Extension Methods Not Working

Unfunded#460created byaboah

$0.00

Question: Can I use SqlKata.Execution AND Dapper ?

Unfunded#464created bym4ss1m0g

$0.00

[Question] Playground source code ?

Unfunded#473created bym4ss1m0g

$0.00

Add Query.Select(IEnumerable<string>) overload

Unfunded#474created bybsagal

$0.00

Group `HAVING` filters

Unfunded#476created byyankyhgoflow

$0.00

WITH(INDEX)

Unfunded#478created bygenerik0

$0.00

Release cycle

Unfunded#479created byyankyhgoflow

$0.00

SqlServerCompiler - ORDER BY uses wrong moniker

Unfunded#480created bySeattleDiver

$0.00

If you get after insert, the same data will be inserted twice.

Unfunded#482created byikuosaito1989

$0.00

Forcing return type when initiating a select query

Unfunded#483created bydom3551-git

$0.00

Wrong file version in 2.3.2 NuGet package

Unfunded#484created bySharparam

$0.00

Oracle SelectRaw Brackets Converted to Quotes

Unfunded#485created byozplanet

$0.00

Atomic Increment?

Unfunded#488created byadhip94

$0.00

Add CancellationToken to Async static methods

Unfunded#302created bytb-mtg

$0.00

IBM AS/400 DB2 Support?

Unfunded#491created bySpuddish

$0.00

What is happening to all these releases!

Unfunded#493created bychrisgate

$0.00

Breaking change introduced in v2.2.3

Unfunded#500created bySharparam

$0.00

Boolean Conditions in Where Clause

Unfunded#503created byadhip94

$0.00

while having multiple selects, auto merge duplicate columns instead of repetition.

Unfunded#505created bytijujohn83

$0.00

Breaking Changes Due to Addition of Optional CancellationToken Parameters

Unfunded#506created bynathanaw

$0.00

`FILTER` clause in `SELECT` clause

Unfunded#507created byyankyhgoflow

$0.00

WhereDatePart error for SQLite

Unfunded#509created bykztneda

$0.00

Prevent database generated columns from being inserted.

Unfunded#339created bygrounzero

$0.00

Join Many to Many Relationship

Unfunded#511created byzahra6688

$0.00

Need help to build sqlkata query without using "SelectRaw" and "WhereRaw" functions

Unfunded#514created byxayaraj

$0.00

Why create a new QueryFactory when it can be assigned via an XQuery property

Unfunded#518created byghost

$0.00

About Clickhouse

Unfunded#520created bysamchenws

$0.00

Visual Studio nuget: Licence HTTP 404 Not found

Unfunded#521created bystrarsis

$0.00

Sqlite InsertGetIdAsync returns 0

Unfunded#522created bygenerik0

$0.00

Unexpected "ORDER BY (SELECT 0)" inside SELECT query - Oracle Compiler

Unfunded#305created byartemiusgreat

$0.00

Playground error messages

Unfunded#525created bymoishyr

$0.00

WhereRaw is not really raw?

Unfunded#528created byspiralw

$0.00

Unicode strings in compiled INSERT Queries.

Unfunded#529created byilya1928

$0.00

SAP Hana Database

Unfunded#531created byRacass

$0.00

Question about converting Offset to accept long instead of int

Unfunded#532created byatdimitrov

$0.00

How can we use T_HAZIRMETIN table name and column name in QueryBuilder. without using nameof.

Unfunded#533created bymummyildiz

$0.00

Possible wrong Opening/ClosingIdentifier for Sqlite compiler

Unfunded#536created bysonerturkkan

$0.00

Plans for commands?

Unfunded#538created byjerry1970

$0.00

WhereContains and friends for PostgresSQL are suboptimal

Unfunded#540created bymindcrash

$0.00

Update that allows you to specify a Query

Unfunded#542created bySeany84

$0.00

SQL Server Legacy Pagination enabled by default

Unfunded#545created byWulfheart

$0.00

Update with inner query

Unfunded#547created byrsr-maersk

$0.00

Ability to pass raw string expressions in insert/delete statements

Unfunded#221created byghost

$0.00

Sonatype SQL injection with ChangeToSqlValue

Unfunded#549created bytskong

$0.00

Arithmetic overflow error converting numeric to data type numeric

Unfunded#550created bygunagururaja

$0.00

QueryFactory IDisposable?

Unfunded#551created bygenerik0

$0.00

Support for `INTO OUTFILE`

Unfunded#555created bykwon0408

$0.00

New NuGet package -> Define

Unfunded#362created bytluyben

$0.00

Changes in 2.0

Unfunded#338created byasherber

$0.00

support UPDATE from one table to another table.

Unfunded#300created byKRperm

$0.00

Add benchmark for Frans Bouma's RawDataAccessBencher

Unfunded#222created byjzabroski

$0.00

SqlKata.Execution problem on nvarchar or unicode characters on update and insert

Unfunded#560created bymojtaba-yekta

$0.00

Limit not being compiled

Unfunded#561created bygaurangfgupta

$0.00

Allow using shorthand notiations in the Query function when defining names of tables

Unfunded#568created byabsundr

$0.00

Compilers CteFinder findInternal always inserts on 0 position for inner query from clauses.

Unfunded#570created byshabanlushaj

$0.00

NullReferenceException for operations on cloned XQuery

Unfunded#572created byp-goodman

$0.00

Release plans?

Unfunded#576created bymnsrulz

$0.00

System.Data.SqlClient.SqlException: 'Incorrect syntax near '`'.'

Unfunded#578created bytalley

$0.00

Sort is changing the number of results

Unfunded#580created byali-sorri

$0.00

Where exists remove select component

Unfunded#581created byxPudda

$0.00

Odd wrapping behavior

Unfunded#583created byRFBomb

$0.00

Create Table builder extensions ?

Unfunded#585created byvirtualvoid

$0.00

Invalid SQL Server query created using WhereIn() and empty arrays

Unfunded#586created bygwheeloc

$0.00

Compare DateTimes with full precision?

Unfunded#587created byntwilson

$0.00

Set CROSS/OUTER APPLY alias

Unfunded#595created byDroppers

$0.00

Columns that contain dots are unexpectedly escaped

Unfunded#596created byjordy758

$0.00

Query.Not() doesn't apply to WhereRaw

Unfunded#598created bySunnyC17

$0.00

Count<T> throws null reference with no rows when upgrading to 2.3.8

Unfunded#600created byMyrmex

$0.00

XQuery: Add support for Exists() and DoesntExist()

Unfunded#334created byahmad-moussawi

$0.00

Add execution tests for Sqlite

Unfunded#605created byahmad-moussawi

$0.00

Join with coalesce

Unfunded#611created bymarekbe

$0.00

Declare InQuery Variables

Unfunded#184created byahmad-moussawi

$0.00

CROSS/OUTER APPLY, LATERAL subqueries support

Unfunded#104created byahmad-moussawi

$0.00

InsertGetId returns 0 on sqlite

Unfunded#368created byfrenkhub

$0.00

How should I insert array into column in postgresql?

Unfunded#274created bymifopen

$0.00

Manually mapping column names to object properties

Unfunded#307created byjoaokanta

$0.00

Let .Limit() accept other types of numeric values

Unfunded#298created byKRperm

$0.00

Unable to provide explicit precedence on combinations such as UNION and INTERSECT

Unfunded#369created byalexmg

$0.00

Mixing `SUM` with other columns

Unfunded#203created bySharparam

$0.00

Query Failing - Oracle Custom Type

Unfunded#319created byjonrmayer

$0.00

OracleCompiler generates invalid multiple row insert

Unfunded#192created byceastwood

$0.00

Different behavior Get(query) and Get()

Unfunded#620created byemaengine

$0.00

Basic problems with generated SQL for Postgres

Unfunded#627created byMortenChristiansen

$0.00

Will Linq be supported in the future?

Unfunded#630created byCricle

$0.00

How can I generic `where column>1+column1`?

Unfunded#636created byCricle

$0.00

Is there an available method to determine whether a data table exists?

Unfunded#638created byVictorTzeng

$0.00

System.Exception: Failed to locate a compiler for 'CompileBasicCondition'

Unfunded#639created byMaYiLagann

$0.00

Result of the query with multiple carriage return line feed is truncated

Unfunded#642created byAlex-Doms

$0.00

[FEATURE REQUEST]: Delta Lake Support

Unfunded#647created byrrekapalli

$0.00

Documentation on Writing a Compiler

Unfunded#648created bylawrence-vo

$0.00

Insert/Update a geometry field

Unfunded#651created bybad-ch

$0.00

How to compare results of two subqueries in where clause SQLKata

Unfunded#653created bysterlyukin

$0.00

Update/Insert statement doesn't accept DbType for parameter arguments

Unfunded#657created byKostetskyiYaroslav

$0.00

Is it possible to query temporal tables with "FOR SYSTEM_TIME?"

Unfunded#658created bymdnpascual

$0.00

Will support `MERGE` operator in feature?

Unfunded#660created byCricle

$0.00

Any plan to add feature to generate Query from raw SQL

Unfunded#669created byspaciandd

$0.00

Value Expressions

Unfunded#670created bydavisylvestre

$0.00

--Oracle11g does not support, "OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY "

Unfunded#672created bymummyildiz

$0.00

Fails to update jsonb field

Unfunded#673created bymesgar

$0.00

Query is generated twice

Unfunded#675created bysuperrnovae

$0.00

PERF: PaginateAsync uses Count(*) to count number of rows

Unfunded#682created bybinoypatel

$0.00

Assigning NULL value to column with AsUpdate throws NotSupportedException

Unfunded#693created bySeanLawless

$0.00

db access where day error No value given for one or more required parameters.

Unfunded#696created byKarimQaderi

$0.00

Error on WhereContains

Unfunded#707created byjoc-luis

$0.00

Getting Raw SQL from the package, without passing it to the database engine

Unfunded#708created byAmin-ir

$0.00

SqlServerCompiler Limit generates different query on compile compared to previous versions

Unfunded#714created bygerneio

$0.00

`With` missing if defined in sub query

Unfunded#717created byfilipagh

$0.00

Recent activities

ahmad-moussawi was rewarded for sqlkata/querybuilder# 33

over 5 years ago

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

over 5 years ago

issuehuntfest funded $ 30.00 for sqlkata/querybuilder# 33

over 5 years ago

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

over 5 years ago

edokan submitted an output to sqlkata/ querybuilder# 50

over 5 years ago

querybuilder

$90.00

Issues

Company

Community

Support

Connect