querybuilder

What's Changed

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

New Contributors

• @gbrunton made their first contribution in https://github.com/sqlkata/querybuilder/pull/467
• @toburger made their first contribution in https://github.com/sqlkata/querybuilder/pull/616

Full Changelog: https://github.com/sqlkata/querybuilder/compare/v2.4.0...v3.0.0-beta

What's Changed

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

New Contributors

• @AEAcceliox made their first contribution in https://github.com/sqlkata/querybuilder/pull/602

Full Changelog: https://github.com/sqlkata/querybuilder/compare/v2.3.9...v2.4.0

Fix null reference exception when cloning the XQuery instance #600

Full Changelog: https://github.com/sqlkata/querybuilder/compare/v2.3.8...v2.3.9

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

What's Changed

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

New Contributors

• @dgeelen-uipath made their first contribution in https://github.com/sqlkata/querybuilder/pull/496
• @alex-tselikovsky made their first contribution in https://github.com/sqlkata/querybuilder/pull/342
• @ChrSteinert made their first contribution in https://github.com/sqlkata/querybuilder/pull/515
• @mnsrulz made their first contribution in https://github.com/sqlkata/querybuilder/pull/524
• @Wulfheart made their first contribution in https://github.com/sqlkata/querybuilder/pull/546
• @User00015 made their first contribution in https://github.com/sqlkata/querybuilder/pull/516
• @tskong made their first contribution in https://github.com/sqlkata/querybuilder/pull/554
• @mattbrailsford made their first contribution in https://github.com/sqlkata/querybuilder/pull/563
• @RFBomb made their first contribution in https://github.com/sqlkata/querybuilder/pull/582
• @allcontributors made their first contribution in https://github.com/sqlkata/querybuilder/pull/590

Full Changelog: https://github.com/sqlkata/querybuilder/compare/v2.3.7...v2.3.8

Increment and Decrement support

Correcting the previous version

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

Fix count required arguments