knex 1.0.0

on Node.js NPM

Breaking changes

• Dropped support for Node 10;
• Replaced unsupported sqlite3 driver with @vscode/sqlite3;
• Changed data structure from RETURNING operation to be consistent with SELECT;
• 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