search

hackariens / strapi

Nouveau projet sous strapi
0 stars 0 forks source link

fix(deps): update dependency knex to v2 [security] - autoclosed #60

Closed renovate[bot] closed 1 year ago

renovate[bot] commented 1 year ago

Mend Renovate

This PR contains the following updates:

Package Change Age Adoption Passing Confidence
knex (source) 0.21.18 -> 2.4.0 age adoption passing confidence

GitHub Vulnerability Alerts

CVE-2016-20018

Knex Knex.js through 2.3.0 has a limited SQL injection vulnerability that can be exploited to ignore the WHERE clause of a SQL query. This vulnerability has been fixed in version 2.4.0.

Release Notes

knex/knex ### [`v2.4.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​240---06-January-2022) [Compare Source](https://togithub.com/knex/knex/compare/2.3.0...2.4.0) ##### New features: - Support partial unique indexes [#​5316](https://togithub.com/knex/knex/issues/5316) - Make compiling SQL in error message optional [#​5282](https://togithub.com/knex/knex/issues/5282) ##### Bug fixes - Insert array into json column [#​5321](https://togithub.com/knex/knex/issues/5321) - Fix unexpected max acquire-timeout [#​5377](https://togithub.com/knex/knex/issues/5377) - Fix: orWhereJson [#​5361](https://togithub.com/knex/knex/issues/5361) - MySQL: Add assertion for basic where clause not to be object or array [#​1227](https://togithub.com/knex/knex/issues/1227) - SQLite: Fix changing the default value of a boolean column in SQLite [#​5319](https://togithub.com/knex/knex/issues/5319) ##### Typings: - add missing type for 'expirationChecker' on PgConnectionConfig [#​5334](https://togithub.com/knex/knex/issues/5334) ### [`v2.3.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​230---31-August-2022) [Compare Source](https://togithub.com/knex/knex/compare/2.2.0...2.3.0) ##### New features: - PostgreSQL: Explicit jsonb support for custom pg clients [#​5201](https://togithub.com/knex/knex/issues/5201) - SQLite: Support returning with sqlite3 and better-sqlite3 [#​5285](https://togithub.com/knex/knex/issues/5285) - MSSQL: Implement mapBinding mssql dialect option [#​5292](https://togithub.com/knex/knex/issues/5292) ##### Typings: - Update types for TS 4.8 [#​5279](https://togithub.com/knex/knex/issues/5279) - Fix typo [#​5267](https://togithub.com/knex/knex/issues/5267) - Fix WhereJsonObject withCompositeTableType [#​5306](https://togithub.com/knex/knex/issues/5306) - Fix AnalyticFunction type [#​5304](https://togithub.com/knex/knex/issues/5304) - Infer specific column value type in aggregations [#​5297](https://togithub.com/knex/knex/issues/5297) ### [`v2.2.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​220---19-July-2022) [Compare Source](https://togithub.com/knex/knex/compare/2.1.0...2.2.0) ##### New features: - Inline primary key creation for postgres flavours [#​5233](https://togithub.com/knex/knex/issues/5233) - SQLite: Add warning for undefined connection file [#​5223](https://togithub.com/knex/knex/issues/5223) - MSSQL: Add JSON parameter support for connection [#​5200](https://togithub.com/knex/knex/issues/5200) ##### Bug fixes: - PostgreSQL: add primaryKey option for uuid [#​5212](https://togithub.com/knex/knex/issues/5212) ##### Typings: - Add promisable and better types [#​5222](https://togithub.com/knex/knex/issues/5222) - Update raw query bind parameter type [#​5208](https://togithub.com/knex/knex/issues/5208) ### [`v2.1.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​210---26-May-2022) [Compare Source](https://togithub.com/knex/knex/compare/2.0.0...2.1.0) ##### New features: - Improve bundling experience to safely import dialects while using static paths [#​5142](https://togithub.com/knex/knex/issues/5142) - Implement extendable builders [#​5041](https://togithub.com/knex/knex/issues/5041) - PostgreSQL: Refresh materialized view concurrently [#​5166](https://togithub.com/knex/knex/issues/5166) ##### Bug fixes: - Use correct paths in package.json browser field [#​5174](https://togithub.com/knex/knex/issues/5174) - MariaDB: Fix 'NULL' returned instead of NULL on MariaDB 10.2.6+ [#​5181](https://togithub.com/knex/knex/issues/5181) - MySQL: fix hasColumn Error (hasColumn ('a_id') is true, but hasColumn('a_Id') is false) [#​5148](https://togithub.com/knex/knex/issues/5148) - MSSQL: Fix .hasTable result when using .withSchema [#​5176](https://togithub.com/knex/knex/issues/5176) - Oracle: correctly INSERTS Buffer [#​4869](https://togithub.com/knex/knex/issues/4869) ##### Typings: - Update type definitions for pg connection [#​5139](https://togithub.com/knex/knex/issues/5139) ### [`v2.0.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​200---21-April-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.7...2.0.0) ##### Breaking changes - Restore sqlite3 package [#​5136](https://togithub.com/knex/knex/issues/5136) ##### Test / internal changes: - Migrate Husky from 4 to 7 [#​5137](https://togithub.com/knex/knex/issues/5137) - Migrate Jake to 10.8.5 [#​5138](https://togithub.com/knex/knex/issues/5138) ### [`v1.0.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​107---13-April-2022) [Compare Source](https://togithub.com/knex/knex/compare/f35f7d4972f47a0a1790b13a555471fe4df0e595...1.0.7) ##### Bug fixes: - CLI: Fix cli migrate:make SQLite dependency [#​5106](https://togithub.com/knex/knex/issues/5106) ### [`v1.0.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​106---12-April-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.5...f35f7d4972f47a0a1790b13a555471fe4df0e595) ##### Bug fixes: - PostgreSQL: Wait for search path to be set before returning connection [#​5107](https://togithub.com/knex/knex/issues/5107) - CLI: No client override during migrate:make [#​5109](https://togithub.com/knex/knex/issues/5109) ### [`v1.0.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​105---05-April-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.4...1.0.5) ##### New features: - Override knexfile options with CLI options [#​4047](https://togithub.com/knex/knex/issues/4047) ##### Bug fixes: - Stringify json value in update [#​5063](https://togithub.com/knex/knex/issues/5063) - Fix isModuleType() for yarn [#​4447](https://togithub.com/knex/knex/issues/4447) - Wrapped Unions Fixes [#​5072](https://togithub.com/knex/knex/issues/5072) - SQLite: Fix [@​vscode-sqlite3](https://togithub.com/vscode-sqlite3) error message [#​5081](https://togithub.com/knex/knex/issues/5081) - CLI: Fix completed migration listing [#​5060](https://togithub.com/knex/knex/issues/5060) ##### Typings: - Make default generic parameters of `Knex` match the generic parameter types of `knex` [#​5021](https://togithub.com/knex/knex/issues/5021) - Update knex types for TS 4.7 [#​5095](https://togithub.com/knex/knex/issues/5095) ### [`v1.0.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​104---13-March-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.3...1.0.4) ##### New features: - Add whereLike functions [#​5044](https://togithub.com/knex/knex/issues/5044) ##### Bug fixes: - Fix orWhereJsonPath clause [#​5022](https://togithub.com/knex/knex/issues/5022) - Subquery in on clause missing parenthesis [#​5049](https://togithub.com/knex/knex/issues/5049) - Rework Union Wrapping [#​5030](https://togithub.com/knex/knex/issues/5030) - Oracle: Fix batch inserts with DEFAULT values with OracleDB [#​2592](https://togithub.com/knex/knex/issues/2592) [#​5037](https://togithub.com/knex/knex/issues/5037) ##### Typings: - Fix types for "returning" methods [#​5031](https://togithub.com/knex/knex/issues/5031) - createTableLike callback should be optional [#​5055](https://togithub.com/knex/knex/issues/5055) ##### Documentation: - Website URL changed to https://knex.github.io/documentation/ ### [`v1.0.3`](https://togithub.com/knex/knex/compare/8fd1f22d2e9ccdd1d98d874d64a255858906d854...e64e37bb39779252050473e8e7598f719ff54418) [Compare Source](https://togithub.com/knex/knex/compare/8fd1f22d2e9ccdd1d98d874d64a255858906d854...1.0.3) ### [`v1.0.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​102---02-February-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.1...8fd1f22d2e9ccdd1d98d874d64a255858906d854) ##### New features: - Support of MATERIALIZED and NOT MATERIALIZED with WITH/CTE [#​4940](https://togithub.com/knex/knex/issues/4940) - Add raw support in onConflict clause [#​4960](https://togithub.com/knex/knex/issues/4960) - Alter nullable constraint when alterNullable is set to true [#​4730](https://togithub.com/knex/knex/issues/4730) - Add alterType parameter for alter function [#​4967](https://togithub.com/knex/knex/issues/4967) - Support string json in json values [#​4988](https://togithub.com/knex/knex/issues/4988) - MySQL: add with clause [#​4508](https://togithub.com/knex/knex/issues/4508) ##### Bug fixes: - Fix error message for missing migration files [#​4937](https://togithub.com/knex/knex/issues/4937) - Move deferrable to after on update/on delete [#​4976](https://togithub.com/knex/knex/issues/4976) - Do not use sys.tables to find if a table exists [#​2328](https://togithub.com/knex/knex/issues/2328) - PostgreSQL: Fix Order nulls [#​4989](https://togithub.com/knex/knex/issues/4989) - MySQL: Fix collation when renaming column [#​2666](https://togithub.com/knex/knex/issues/2666) - SQLite: Same boolean handling in better-sqlite3 as in sqlite3 [#​4982](https://togithub.com/knex/knex/issues/4982) ##### Typings: - WhereILike - fix typo [#​4941](https://togithub.com/knex/knex/issues/4941) ### [`v1.0.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​101---16-January-2022) [Compare Source](https://togithub.com/knex/knex/compare/1.0.0...1.0.1) ##### Bug fixes: - Fix package.json metadata ### [`v1.0.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​100---16-January-2022) [Compare Source](https://togithub.com/knex/knex/compare/380cebefcbf04219f51dfeb0e06efc735796c148...1.0.0) ##### 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](https://togithub.com/knex/knex/issues/4781) - Support zero precision in timestamp/datetime [#​4784](https://togithub.com/knex/knex/issues/4784) - Support whereLike and whereILike [#​4779](https://togithub.com/knex/knex/issues/4779) - Add JSDoc (TS flavor) to stub files [#​4809](https://togithub.com/knex/knex/issues/4809) - Allow skip binding in limit and offset [#​4811](https://togithub.com/knex/knex/issues/4811) - Support creating a new table in the database based on another table [#​4821](https://togithub.com/knex/knex/issues/4821) - Accept Raw on onIn joins [#​4830](https://togithub.com/knex/knex/issues/4830) - Implement support for custom seed sources [#​4842](https://togithub.com/knex/knex/issues/4842) - Add binary uuid option [#​4836](https://togithub.com/knex/knex/issues/4836) - ForUpdate array parameter [#​4882](https://togithub.com/knex/knex/issues/4882) - Add camel case to timestamps method [#​4803](https://togithub.com/knex/knex/issues/4803) - Advanced JSON support [#​4859](https://togithub.com/knex/knex/issues/4859) - Add type to TypeScript knexfile [#​4909](https://togithub.com/knex/knex/issues/4909) - Checks Constraints Support [#​4874](https://togithub.com/knex/knex/issues/4874) - Support creating multiple PKs with increments [#​4903](https://togithub.com/knex/knex/issues/4903) - Enable wrapIdentifier for SQLite .hasTable [#​4915](https://togithub.com/knex/knex/issues/4915) - MSSQL: Add support for unique constraint [#​4887](https://togithub.com/knex/knex/issues/4887) - SQLite: New dialect, using better-sqlite3 driver [#​4871](https://togithub.com/knex/knex/issues/4871) - SQLite: Switch to [@​vscode/sqlite3](https://togithub.com/vscode/sqlite3) [#​4866](https://togithub.com/knex/knex/issues/4866) - SQLite: Support createViewOrReplace [#​4856](https://togithub.com/knex/knex/issues/4856) - SQLite: Support RETURNING statements for better-sqlite3 driver [#​4934](https://togithub.com/knex/knex/issues/4934) - PostgreSQL: Support JOIN and USING syntax for Delete Statement [#​4800](https://togithub.com/knex/knex/issues/4800) ##### Bug fixes: - Fix overzealous warning on use of whereNot with "in" or "between" [#​4780](https://togithub.com/knex/knex/issues/4780) - Fix Union all + first syntax error [#​4799](https://togithub.com/knex/knex/issues/4799) - Make view columns optional in create view like [#​4829](https://togithub.com/knex/knex/issues/4829) - Insert lock row fix during migration [#​4865](https://togithub.com/knex/knex/issues/4865) - Fix for createViewOrReplace [#​4856](https://togithub.com/knex/knex/issues/4856) - SQLite: Fix foreign key constraints when altering a table [#​4189](https://togithub.com/knex/knex/issues/4189) - MySQL: Validate connection fix [#​4794](https://togithub.com/knex/knex/issues/4794) - MySQL: Set comment size warning limit to 1024 [#​4867](https://togithub.com/knex/knex/issues/4867) ##### Typings: - Allow string indexType in index creation [#​4791](https://togithub.com/knex/knex/issues/4791) - Add missing ints typings [#​4832](https://togithub.com/knex/knex/issues/4832) - Returning method types [#​4881](https://togithub.com/knex/knex/issues/4881) - Improve columnInfo type [#​4868](https://togithub.com/knex/knex/issues/4868) ### [`v0.95.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09515---22-December-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148) ##### Bug fixes: - Oracle: - MariaDB: lock row fix during migration in MariaDB and Oracle [#​4865](https://togithub.com/knex/knex/issues/4865) ### [`v0.95.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09514---09-November-2021) [Compare Source](https://togithub.com/knex/knex/compare/29ac476b2bfe7593118da2884fae23a2e6004414...0.95.14) ##### Bug fixes: - MySQL: mysql2 dialect validate connection fix [#​4794](https://togithub.com/knex/knex/issues/4794) ### [`v0.95.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09513---02-November-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.12...29ac476b2bfe7593118da2884fae23a2e6004414) ##### Bug fixes: - PostgreSQL: Support zero precision in timestamp/datetime [#​4784](https://togithub.com/knex/knex/issues/4784) ##### Typings: - Allow string indexType in index creation [#​4791](https://togithub.com/knex/knex/issues/4791) ### [`v0.95.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09512---28-October-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.11...0.95.12) ##### New features: - New dialect: CockroachDB [#​4742](https://togithub.com/knex/knex/issues/4742) - New dialect: pg-native [#​4327](https://togithub.com/knex/knex/issues/4327) - CockroachDB: add support for upsert [#​4767](https://togithub.com/knex/knex/issues/4767) - PostgreSQL: Support SELECT .. FOR NO KEY UPDATE / KEY SHARE row level locking clauses [#​4755](https://togithub.com/knex/knex/issues/4755) - PostgreSQL: Add support for 'CASCADE' in PostgreSQL 'DROP SCHEMA' queries [#​4713](https://togithub.com/knex/knex/issues/4713) - MySQL: Add storage engine index Type support to index() and unique() schema [#​4756](https://togithub.com/knex/knex/issues/4756) - MSSQL: Support table.primary, table.unique variant with options object [#​4710](https://togithub.com/knex/knex/issues/4710) - SQLite: Add setNullable support to SQLite [#​4684](https://togithub.com/knex/knex/issues/4684) - Add geometry column building [#​4776](https://togithub.com/knex/knex/issues/4776) - Add support for creating table copies [#​1373](https://togithub.com/knex/knex/issues/1373) - Implement support for views and materialized views [#​1626](https://togithub.com/knex/knex/issues/1626) - Implement partial index support [#​4768](https://togithub.com/knex/knex/issues/4768) - Support for 'is null' in 'order by' [#​3667](https://togithub.com/knex/knex/issues/3667) ##### Bug fixes: - Fix support for Oracle connections passed via knex.connection() [#​4757](https://togithub.com/knex/knex/issues/4757) - Avoid inserting multiple locks if a migration lock already exists [#​4694](https://togithub.com/knex/knex/issues/4694) ##### Typings: - Some TableBuilder methods return wrong types [#​4764](https://togithub.com/knex/knex/issues/4764) - Update JoinRaw bindings type to accept arrays [#​4752](https://togithub.com/knex/knex/issues/4752) - fix onDelete/onUpdate for ColumnBuilder [#​4656](https://togithub.com/knex/knex/issues/4656) ### [`v0.95.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09511---03-September-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.10...0.95.11) ##### New features: - Add support for nullability modification via schema builder (table.setNullable() and table.dropNullable()) [#​4657](https://togithub.com/knex/knex/issues/4657) - MySQL: Add support for mysql/mariadb-client JSON parameters in connectionURIs [#​4629](https://togithub.com/knex/knex/issues/4629) - MSSQL: Support comments as MS_Description properties [#​4632](https://togithub.com/knex/knex/issues/4632) ##### Bug fixes: - Fix Analytic orderBy and partitionBy to follow the SQL documentation [#​4602](https://togithub.com/knex/knex/issues/4602) - CLI: fix migrate:up for migrations disabling transactions [#​4550](https://togithub.com/knex/knex/issues/4550) - SQLite: Fix adding a column with a foreign key constraint in SQLite [#​4649](https://togithub.com/knex/knex/issues/4649) - MSSQL: columnInfo() support case-sensitive database collations [#​4633](https://togithub.com/knex/knex/issues/4633) - MSSQL: Generate valid SQL for withRecursive() [#​4514](https://togithub.com/knex/knex/issues/4514) - Oracle: withRecursive: omit invalid RECURSIVE keyword, include column list [#​4514](https://togithub.com/knex/knex/issues/4514) ##### Improvements: - Add .mjs migration and seed stubs [#​4631](https://togithub.com/knex/knex/issues/4631) - SQLite: Clean up DDL handling and move all operations to the parser-based approach [#​4648](https://togithub.com/knex/knex/issues/4648) ### [`v0.95.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09510---20-August-2021) [Compare Source](https://togithub.com/knex/knex/compare/102a44d7a5fe641bdee8f7e66f6518f5418ff93e...0.95.10) ##### Improvements: - Use sys info function instead of connection db name [#​4623](https://togithub.com/knex/knex/issues/4623) ##### Typings: - Deferrable and withkeyName should not be in ColumnBuilder [#​4600](https://togithub.com/knex/knex/issues/4600) ### [`v0.95.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0959---31-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.8...102a44d7a5fe641bdee8f7e66f6518f5418ff93e) ##### New features: - Oracle: support specifying schema for dropTable and dropSequence [#​4596](https://togithub.com/knex/knex/issues/4596) - Oracle: support specifying schema for autoincrement [#​4594](https://togithub.com/knex/knex/issues/4594) ##### Typings: - Add TypeScript support for deferrable, new Primary/Unique syntax [#​4589](https://togithub.com/knex/knex/issues/4589) ### [`v0.95.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0958---25-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/3089d50ec9e7762e120af77a46d808162a048b0e...0.95.8) ##### New features: - Add deferrable support for constraint [#​4584](https://togithub.com/knex/knex/issues/4584) - Implement delete with join [#​4568](https://togithub.com/knex/knex/issues/4568) - Add DPI error codes for Oracle [#​4536](https://togithub.com/knex/knex/issues/4536) ##### Bug fixes: - Fixing PostgreSQL datetime and timestamp column created with wrong format [#​4578](https://togithub.com/knex/knex/issues/4578) ##### Typings: - Improve analytic types [#​4576](https://togithub.com/knex/knex/issues/4576) - MSSQL: Add trustServerCertificate option [#​4500](https://togithub.com/knex/knex/issues/4500) ### [`v0.95.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0957---10-July-2021) [Compare Source](https://togithub.com/knex/knex/compare/fff6eb15d7088d4198650a2c6e673dedaf3b8f36...3089d50ec9e7762e120af77a46d808162a048b0e) ##### New features: - Add ability to omit columns on an onConflict().ignore() [#​4557](https://togithub.com/knex/knex/issues/4557) - CLI: Log error message [#​4534](https://togithub.com/knex/knex/issues/4534) ##### Typings: - Export Knex.TransactionConfig [#​4498](https://togithub.com/knex/knex/issues/4498) - Include options object in count(Distinct) typings [#​4491](https://togithub.com/knex/knex/issues/4491) - Add types for analytic functions [#​4544](https://togithub.com/knex/knex/issues/4544) ### [`v0.95.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0956---17-May-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.5...fff6eb15d7088d4198650a2c6e673dedaf3b8f36) ##### Typings: - Export TransactionProvider type [#​4489](https://togithub.com/knex/knex/issues/4489) ### [`v0.95.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0955---11-May-2021) [Compare Source](https://togithub.com/knex/knex/compare/8cfad286f246aff7455784b51751fdd17ba24c4c...0.95.5) ##### New features: - SQLite: Add support for file open flags [#​4446](https://togithub.com/knex/knex/issues/4446) - Add .cjs extension to Seeder.js to support Node ESM [#​4381](https://togithub.com/knex/knex/issues/4381) [#​4382](https://togithub.com/knex/knex/issues/4382) ##### Bug fixes: - Remove peerDependencies to avoid auto-install on npm 7 [#​4480](https://togithub.com/knex/knex/issues/4480) ##### Typings: - Fix typing for increments and bigIncrements [#​4406](https://togithub.com/knex/knex/issues/4406) - Add typings for on JoinClause for onVal [#​4436](https://togithub.com/knex/knex/issues/4436) - Adding Type Definition for isTransaction [#​4418](https://togithub.com/knex/knex/issues/4418) - Export client class from knex namespace [#​4479](https://togithub.com/knex/knex/issues/4479) ### [`v0.95.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0954---26-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.3...8cfad286f246aff7455784b51751fdd17ba24c4c) ##### Typings: - Fix mistyping of stream [#​4400](https://togithub.com/knex/knex/issues/4400) ### [`v0.95.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0953---25-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.2...0.95.3) ##### New features: - PostgreSQL: Add "same" as operator [#​4372](https://togithub.com/knex/knex/issues/4372) - MSSQL: Improve an estimate of the max comment length [#​4362](https://togithub.com/knex/knex/issues/4362) - Throw an error if negative offset is provided [#​4361](https://togithub.com/knex/knex/issues/4361) ##### Bug fixes: - Fix timeout method [#​4324](https://togithub.com/knex/knex/issues/4324) - SQLite: prevent dropForeign from being silently ignored [#​4376](https://togithub.com/knex/knex/issues/4376) ##### Typings: - Allow config.client to be non-client instance [#​4367](https://togithub.com/knex/knex/issues/4367) - Add dropForeign arg type for single column [#​4363](https://togithub.com/knex/knex/issues/4363) - Update typings for TypePreservingAggregation and stream [#​4377](https://togithub.com/knex/knex/issues/4377) ### [`v0.95.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0952---11-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/aa7121fa9823b982684c89b7fcb60166a845711a...0.95.2) ##### New features: - Improve ESM import support [#​4350](https://togithub.com/knex/knex/issues/4350) ##### Bug fixes: - CLI: update ts.stub files to new TypeScript namespace [#​4344](https://togithub.com/knex/knex/issues/4344) - CLI: fix TypeScript migration stub after 0.95.0 changes [#​4366](https://togithub.com/knex/knex/issues/4366) ##### Typings: - Move QueryBuilder and KnexTimeoutError into knex namespace [#​4358](https://togithub.com/knex/knex/issues/4358) ##### Test / internal changes: - Unify db test helpers [#​4356](https://togithub.com/knex/knex/issues/4356) ### [`v0.95.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​09515---22-December-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.95.0...aa7121fa9823b982684c89b7fcb60166a845711a) ##### Bug fixes: - Oracle: - MariaDB: lock row fix during migration in MariaDB and Oracle [#​4865](https://togithub.com/knex/knex/issues/4865) ### [`v0.95.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​0950---03-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/823c7b60f74fb16bcb8a8230afe1fea6673c2bd0...0.95.0) Note: there are many breaking changes in this version, particularly in TypeScript support. Please see `UPGRADING.md` for details. ##### New features: - Add transaction isolation support [#​4185](https://togithub.com/knex/knex/issues/4185) - Add analytic functions [#​4188](https://togithub.com/knex/knex/issues/4188) - Change default to not trigger a promise rejection for transactions with a specified handler [#​4195](https://togithub.com/knex/knex/issues/4195) - Make toSQL().toNative() work for Raw to match the API for QueryBuilder [#​4058](https://togithub.com/knex/knex/issues/4058) - Allow 'match' operator [#​3569](https://togithub.com/knex/knex/issues/3569) - Support optimizer hints [#​4243](https://togithub.com/knex/knex/issues/4243) - Add parameter to prevent autoincrement columns from being primary keys [#​4266](https://togithub.com/knex/knex/issues/4266) - Make "first" and "pluck" mutually exclusive [#​4280](https://togithub.com/knex/knex/issues/4280) - Added merge strategy to allow selecting columns to upsert. [#​4252](https://togithub.com/knex/knex/issues/4252) - Throw error if the array passed to insert is empty [#​4289](https://togithub.com/knex/knex/issues/4289) - Events: introduce queryContext on query-error [#​4301](https://togithub.com/knex/knex/issues/4301) - CLI: Use UTC timestamp for new migrations [#​4245](https://togithub.com/knex/knex/issues/4245) - MSSQL: Replace MSSQL dialect with Tedious.js implementation [#​2857](https://togithub.com/knex/knex/issues/2857) [#​4281](https://togithub.com/knex/knex/issues/4281) - MSSQL: Use "nvarchar(max)" for ".json()" [#​4278](https://togithub.com/knex/knex/issues/4278) - MSSQL: Schema builder - add predictable constraint names for default values [#​4319](https://togithub.com/knex/knex/issues/4319) - MSSQL: Schema builder - attempt to drop default constraints when changing default value on columns [#​4321](https://togithub.com/knex/knex/issues/4321) - SQLite: Fallback to json for sqlite3 when using jsonb [#​4186](https://togithub.com/knex/knex/issues/4186) - SQLite: Return complete list of DDL commands for creating foreign keys [#​4194](https://togithub.com/knex/knex/issues/4194) - SQLite: Support dropping composite foreign keys [#​4202](https://togithub.com/knex/knex/issues/4202) - SQLite: Recreate indices when altering a table [#​4277](https://togithub.com/knex/knex/issues/4277) - SQLite: Add support for altering columns [#​4322](https://togithub.com/knex/knex/issues/4322) ##### Bug fixes: - Fix issue with .withSchema usage with joins on a subquery [#​4267](https://togithub.com/knex/knex/issues/4267) - Fix issue with schema usage with FROM clause contain QueryBuilder, function or Raw [#​4268](https://togithub.com/knex/knex/issues/4268) - CLI: Address raised security warnings by dropping liftoff [#​4122](https://togithub.com/knex/knex/issues/4122) - CLI: Fix an issue with npm@7 and ESM when `type` was set to `'module'` in `package.json` [#​4295](https://togithub.com/knex/knex/issues/4295) - PostgreSQL: Add check to only create native enum once [#​3658](https://togithub.com/knex/knex/issues/3658) - SQLite: Fix foreign key "on delete" when altering a table [#​4225](https://togithub.com/knex/knex/issues/4225) - SQLite: Made the constraint detection case-insensitive [#​4330](https://togithub.com/knex/knex/issues/4330) - MySQL: Keep auto increment after rename [#​4266](https://togithub.com/knex/knex/issues/4266) - MSSQL: don't raise query-error twice [#​4314](https://togithub.com/knex/knex/issues/4314) - MSSQL: Alter column must have its own query [#​4317](https://togithub.com/knex/knex/issues/4317) ##### Typings: - TypeScript 4.1+ is now required - Add missing onConflict overrides [#​4182](https://togithub.com/knex/knex/issues/4182) - Introduce the "infamous triplet" export [#​4181](https://togithub.com/knex/knex/issues/4181) - Fix type definition of Transaction [#​4172](https://togithub.com/knex/knex/issues/4172) - Add typedefinitions for havingNotIn [#​4265](https://togithub.com/knex/knex/issues/4265) - Include 'name' property in MigratorConfig [#​4300](https://togithub.com/knex/knex/issues/4300) - Improve join and conflict types [#​4318](https://togithub.com/knex/knex/issues/4318) - Fix ArrayIfAlready type [#​4331](https://togithub.com/knex/knex/issues/4331) ##### Test / internal changes: - Drop global Knex.raw [#​4180](https://togithub.com/knex/knex/issues/4180) - Stop using legacy url.parse API [#​3702](https://togithub.com/knex/knex/issues/3702) - Various internal refactorings [#​4175](https://togithub.com/knex/knex/issues/4175) [#​4177](https://togithub.com/knex/knex/issues/4177) [#​4178](https://togithub.com/knex/knex/issues/4178) [#​4192](https://togithub.com/knex/knex/issues/4192) - Refactor to classes [#​4190](https://togithub.com/knex/knex/issues/4190) [#​4191](https://togithub.com/knex/knex/issues/4191) [#​4193](https://togithub.com/knex/knex/issues/4193) [#​4210](https://togithub.com/knex/knex/issues/4210) [#​4253](https://togithub.com/knex/knex/issues/4253) - Move transaction type tests to TSD [#​4208](https://togithub.com/knex/knex/issues/4208) - Clean up destroy logic [#​4248](https://togithub.com/knex/knex/issues/4248) - Colorize code snippets in readme files [#​4234](https://togithub.com/knex/knex/issues/4234) - Add "Ecosystem" documentation for Knex plugins [#​4183](https://togithub.com/knex/knex/issues/4183) - Documentation cleanup - SQLite: Use SQLite "rename column" instead of a DDL helper [#​4200](https://togithub.com/knex/knex/issues/4200) - SQLite: Simplify reinsert logic when altering a table [#​4272](https://togithub.com/knex/knex/issues/4272) ### [`v0.21.21`](https://togithub.com/knex/knex/compare/4f0122283c8a7e3f2cc187d925e2bf1098c00bad...823c7b60f74fb16bcb8a8230afe1fea6673c2bd0) [Compare Source](https://togithub.com/knex/knex/compare/4f0122283c8a7e3f2cc187d925e2bf1098c00bad...823c7b60f74fb16bcb8a8230afe1fea6673c2bd0) ### [`v0.21.20`](https://togithub.com/knex/knex/compare/0d474aaab4546075013f5c198d0186f1b11fc57f...4f0122283c8a7e3f2cc187d925e2bf1098c00bad) [Compare Source](https://togithub.com/knex/knex/compare/0d474aaab4546075013f5c198d0186f1b11fc57f...4f0122283c8a7e3f2cc187d925e2bf1098c00bad) ### [`v0.21.19`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#​02119---02-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/d2f8a1b1d5d48a6e668f1fab39c08ce76daf587c...0d474aaab4546075013f5c198d0186f1b11fc57f) - SQLite: Made the constraint detection case-insensitive [#​4332](https://togithub.com/knex/knex/issues/4332)

Configuration

📅 Schedule: Branch creation - "" (UTC), Automerge - At any time (no schedule defined).

🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.

♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

This PR has been generated by Mend Renovate. View repository job log here.