3.1.0 - 8 December, 2023

Bug fixes

• andWhereNotJsonObject calling wrong function (#5683)
• PostgreSQL: fix error when setting query_timeout (#5673)
• MySQL: Missing comments on delete, update and insert (#5738)
• MySQL: Fixed issue with bigincrements not working with composite primary key - #5341 (#5343)

Types

• Add type definitions for orHavingNull and orHavingNotNull (#5669)
• Import knex as type in TS migration template (#5741)
• Fix conditional constraint error (#5747)
• PostgreSQL: Fix typing to reflect pg typing change (#5647)

New features

• Add transactor.parentTransaction (#5567)
• MySQL: Added implementation for upsert (#5743)
• Oracle: Support Object Names Greater than 30 Characters for Oracle DB Versions 12.2 and Greater (#5197)

3.0.1 - 6 October, 2023

• Build fix

3.0.0 - 6 October, 2023

• Fix raw bindings typing (#5401)
• Fix migrate:unlock when used with custom identifier wrapping. (#5353)
• Fix driver options specified with .options() method being ignored for oracledb dialect (#5123)
• Drop compatibility for Node < 16
• Fix knex d.ts to work with mixed modules (#5659)
• Fix Lexical error from "Instaed" to "Instead" (#5655)

Bug fixes

• Fix Linting #5455 - #5460

2.5.1 - 12 July, 2023

Bug fixes

• Fix Linting #5455 - #5460

2.5.0 - 08 July, 2023

New features

• Add uuid helper function (#5617)
• Add nativeBindings option to better-sqlite3 options (#5461)
• Add QueryBuilder#updateFrom (#5386)
• Add readonly transaction access mode (#5445)
• Add readonly option to Better-SQLite3 (#5530)
• Add EXCEPT as a valid keyword (#5357)
• Add ability to prepend query comments (#5289)
• Add fetchAsString option (#5484)

Bug fixes

• Avoid password leaks on query logs (#5559)
• Add knex.mjs to files in package.json (#5518)
• Handle numeric array elements in .orderBy() (#5551)
• Attach error handler early enough (#5552)
• Fix Returning * in Oracle (#5598)
• Fix indexType option in Postgres (#5601)
• Add mjs extension type (#5616)
• Use implicit check on json fields for OracleDB (#5478)
• Fix when manually close source stream (#5466)
• Fix case sensitive issue with get table (#5509)

Typings

• Add Object syntax overload to increment method (#5512)
• Add object syntax overload to decrement method (#5555)
• Fix typing for toSql (#5594)
• Add ResolveTableType for .merge() (#5605)
• Add missing types for havingNull and havingNotNull (#5529)
• Add collate to the columnbuilder interface (#5568)
• TableBuilder methods return the SchemaBuilder. (#5486)

2.4.2 - 22 January, 2023

Bug fixes

• CLI: Fix incorrent EOL causing errors on Linux #5455

2.4.1 - 18 January, 2023

Bug fixes

• PostgreSQL: Fix Malformed array literal 2.4.0 Regression #5439

2.4.0 - 06 January, 2023

New features:

• Support partial unique indexes #5316
• Make compiling SQL in error message optional #5282

Bug fixes

• Insert array into json column #5321
• Fix unexpected max acquire-timeout #5377
• Fix: orWhereJson #5361
• MySQL: Add assertion for basic where clause not to be object or array #1227
• SQLite: Fix changing the default value of a boolean column in SQLite #5319

Typings:

• add missing type for 'expirationChecker' on PgConnectionConfig #5334

2.3.0 - 31 August, 2022

New features:

• PostgreSQL: Explicit jsonb support for custom pg clients #5201
• SQLite: Support returning with sqlite3 and better-sqlite3 #5285
• MSSQL: Implement mapBinding mssql dialect option #5292

Typings:

• Update types for TS 4.8 #5279
• Fix typo #5267
• Fix WhereJsonObject withCompositeTableType #5306
• Fix AnalyticFunction type #5304
• Infer specific column value type in aggregations #5297

2.2.0 - 19 July, 2022

New features:

• Inline primary key creation for postgres flavours #5233
• SQLite: Add warning for undefined connection file #5223
• MSSQL: Add JSON parameter support for connection #5200

Bug fixes:

• PostgreSQL: add primaryKey option for uuid #5212

Typings:

• Add promisable and better types #5222
• Update raw query bind parameter type #5208