knex
3.3.0 · 26 Jun 2026MIT7.2M / weekRepositoryHomepagenpmAtom feed
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
sqlite3driver with@vscode/sqlite3; - Breaking
Changed data structure from
RETURNINGoperation to be consistent withSELECT; - Breaking
Changed Migrator to return list of migrations as objects consistently.
Security
1 advisory affects 1.0.0; 2.4.0 fixes them
- HighKnex.js has a limited SQL injection vulnerabilityGHSA-4jv9-3563-23j3 · 19 Dec 2022Fixed in 2.4.0
Release note
1.0.0 - 16 January, 2022
Breaking changes
- Breaking
Dropped support for Node 10;
- Breaking
Replaced unsupported
sqlite3driver with@vscode/sqlite3; - Breaking
Changed data structure from
RETURNINGoperation to be consistent withSELECT; - 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
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.