Packages

knex

3.3.0 · 26 Jun 2026MIT7.2M / weekRepositoryHomepagenpmAtom feed

Your version

2.5.0

8 Jul 2023Where it was published

2.5.1 is the newest release of 2.x.

In short

15 new9 fixed1 changed

Release note

2.5.0 - 08 July, 2023

New features

  • Add uuid helper function

  • Add nativeBindings option to better-sqlite3 options

  • Add QueryBuilder#updateFrom

  • Add readonly transaction access mode

  • Add readonly option to Better-SQLite3

  • Add EXCEPT as a valid keyword

  • Add ability to prepend query comments

  • Add fetchAsString option

Bug fixes

  • Avoid password leaks on query logs

  • Add knex.mjs to files in package.json

  • Handle numeric array elements in .orderBy()

  • Attach error handler early enough

  • Fix Returning * in Oracle

  • Fix indexType option in Postgres

  • Add mjs extension type

  • Use implicit check on json fields for OracleDB

  • Fix when manually close source stream

  • Fix case sensitive issue with get table

Typings

  • Add Object syntax overload to increment method

  • Add object syntax overload to decrement method

  • Fix typing for toSql

  • Add ResolveTableType for .merge()

  • Add missing types for havingNull and havingNotNull

  • Add collate to the columnbuilder interface

  • TableBuilder methods return the SchemaBuilder.

A whole project to check? Paste its package.json in the dependency check: every deprecated, outdated or vulnerable dependency, with what to upgrade to. Free, no account.