3.1.0

Features

• transactor.parentTransaction — access parent transaction context
• MySQL upsert support
• Oracle: support object names >30 characters (DB 12.2+)

Fixes

• andWhereNotJsonObject calling wrong function
• PostgreSQL query_timeout setting error
• MySQL: missing comments on delete/update/insert operations
• MySQL: bigincrements broken with composite primary keys
• Po...

• Fix broken release

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)

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

##...

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

• Fix Postgres Malformed array literal 2.4.0 Regression - https://github.com/knex/knex/pull/5439

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...

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 ty...

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