v3.0.0-beta

What's Changed

• Fixes empty identifier issue by @gbrunton in #467
• Issue 182 - delete join support by @ahmad-moussawi in #614
• Close issues after 30days if no reply by @ahmad-moussawi in #615
• Fix places where the parameterPlaceholder is hardcoded to a ? by @toburger in #616
• Iss 507 support filter clause by @ahmad-moussawi in #617
• Iss 581 where exists remove select by @ahmad-moussawi in #618
• Fix for Oracle insert many by @mathijs-dumon in #557

New Contributors

• @gbrunton made their first contribution in #467
• @toburger made their first contribution in #616

Full Changelog: v2.4.0...v3.0.0-beta

v2.4.0

What's Changed

• Add more execution test for InlineTable, Variable by @ahmad-moussawi in #603
• Fix xunit warnings by @ahmad-moussawi in #604
• add test for Exists/NotExists by @ahmad-moussawi in #606
• Feature 605 sqlite execution test by @ahmad-moussawi in #607
• iss-532: Offset is now long instead of int by @ahmad-moussawi in #608
• Fix license URL by @ahmad-moussawi in #609
• update dapper version from 1.50.5 to 2.0.123 by @AEAcceliox in #602

New Contributors

• @AEAcceliox made their first contribution in #602

Full Changelog: v2.3.9...v2.4.0

v2.3.9

Fix null reference exception when cloning the XQuery instance #600

Full Changelog: v2.3.8...v2.3.9

v2.3.8

Check https://sqlkata.com/release/v2.3.8

What's Changed

• Add Select overload with IEnumerable by @asherber in #502
• Make white space consistent. by @dgeelen-uipath in #496
• Make sure that tests use a predictable time zone. by @dgeelen-uipath in #497
• changing string concatenation with StringBuilder.Append in Helper.ReplaceAll by @alex-tselikovsky in #342
• Delegate where(boolean) to WhereTrue/WhereFalse methods by @ahmad-moussawi in #510
• Change License Tag in the *.csproj file by @ChrSteinert in #515
• Allow for ad-hoc table CTEs with parameterized data by @mnsrulz in #524
• use ilike for case insensitive search in PostgreSQL by @ahmad-moussawi in #544
• Disable SQL Legacy Pagination by default by @Wulfheart in #546
• fix Query Timeout is overridden by @ahmad-moussawi in #552
• use Legacy Pagination for Unit Test by @ahmad-moussawi in #553
• Include/IncludeMany on nullable FK no longer throws exception. by @User00015 in #516
• Escape single quotes for sql injection by @tskong in #554
• allow select without table to support cross apply by @mnsrulz in #541
• compile where clause when no table is present by @mnsrulz in #559
• De-gender comments by @mattbrailsford in #563
• Include XML Documentation File by @RFBomb in #582
• docs: add mnsrulz as a contributor for code by @allcontributors in #590

New Contributors

• @dgeelen-uipath made their first contribution in #496
• @alex-tselikovsky made their first contribution in #342
• @ChrSteinert made their first contribution in #515
• @mnsrulz made their first contribution in #524
• @Wulfheart made their first contribution in #546
• @User00015 made their first contribution in #516
• @tskong made their first contribution in #554
• @mattbrailsford made their first contribution in #563
• @RFBomb made their first contribution in #582
• @allcontributors made their first contribution in #590

Full Changelog: v2.3.7...v2.3.8

Test release v2.3.7

add AssemblyVersion in CI

v2.3.4

Increment and Decrement support

v2.3.3

Correcting the previous version

v2.2.3

Merge pull request #429 from Leon99/master

Add async overload for columns+values insert

Latest version of Humanizer

v2.3.2

upgrade to .net5

Latest version of Humanizer

This release uses the latest version of Humanizer to avoid dependencies conflict