Oracle, SQLite and Firebird Compilers are now available for SqlKata

One year after the launching of the stable version, we’ve got a lot of great feedback from the community.

One of the most requested features are Oracle and SQLite support.

Thanks for https://twitter.com/tomaszlaguz for his Oracle support, followed by a patch to support Oracle 12c from https://github.com/mathijs-dumon.

One of the biggest challenge on supporting different compilers in SqlKata is the implementation of Data Pagination, each engine have it’s own way to implement this.

for example in the old Oracle versions to get the records from the 2nd page you need to do two nested subqueries write something like

Fortunately most of the modern database vendor supports the SQL standard

OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY

Another great feature added is the Operator Whitelisting technique, this will save you from potentials SQL Injection techniques.

Operator whitelisting

The latest version is published now on NuGet.

Follow and Star the project on Github https://github.com/sqlkata/querybuilder and checkout the latest documentation on https://sqlkata.com

I am Ahmad Moussawi, Follow me on Twitter https://twitter.com/ahmadmuzavi for the latest updates on SqlKata.

Thanks for reading.