Packages

knex

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

Your version

1.0.0

major16 Jan 2022Where it was published

1.0.7 is the newest release of 1.x.

In short

4 breaking24 new7 fixed2 changed

  • Breaking

    Dropped support for Node 10;

  • Breaking

    Replaced unsupported sqlite3 driver with @vscode/sqlite3;

  • Breaking

    Changed data structure from RETURNING operation to be consistent with SELECT;

  • Breaking

    Changed Migrator to return list of migrations as objects consistently.

Security

1 advisory affects 1.0.0; 2.4.0 fixes them

Release note

1.0.0 - 16 January, 2022

Breaking changes

  • Breaking

    Dropped support for Node 10;

  • Breaking

    Replaced unsupported sqlite3 driver with @vscode/sqlite3;

  • Breaking

    Changed data structure from RETURNING operation to be consistent with SELECT;

  • Breaking

    Changed Migrator to return list of migrations as objects consistently.

New features

  • Support fromRaw #4781

  • Support zero precision in timestamp/datetime #4784

  • Support whereLike and whereILike #4779

  • Add JSDoc (TS flavor) to stub files #4809

  • Allow skip binding in limit and offset #4811

  • Support creating a new table in the database based on another table #4821

  • Accept Raw on onIn joins #4830

  • Implement support for custom seed sources #4842

  • Add binary uuid option #4836

  • ForUpdate array parameter #4882

  • Add camel case to timestamps method #4803

  • Advanced JSON support #4859

  • Add type to TypeScript knexfile #4909

  • Checks Constraints Support #4874

  • Support creating multiple PKs with increments #4903

  • Enable wrapIdentifier for SQLite .hasTable #4915

  • MSSQL: Add support for unique constraint #4887

  • SQLite: New dialect, using better-sqlite3 driver #4871

  • SQLite: Switch to @vscode/sqlite3 #4866

  • SQLite: Support createViewOrReplace #4856

  • SQLite: Support RETURNING statements for better-sqlite3 driver #4934

  • PostgreSQL: Support JOIN and USING syntax for Delete Statement #4800

Bug fixes

  • Fix overzealous warning on use of whereNot with "in" or "between" #4780

  • Fix Union all + first syntax error #4799

  • Make view columns optional in create view like #4829

  • Insert lock row fix during migration #4865

  • Fix for createViewOrReplace #4856

  • SQLite: Fix foreign key constraints when altering a table #4189

  • MySQL: Validate connection fix #4794

  • MySQL: Set comment size warning limit to 1024 #4867

Typings

  • Allow string indexType in index creation #4791

  • Add missing ints typings #4832

  • Returning method types #4881

  • Improve columnInfo type #4868

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.