knex/knex
### [`v1.0.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#105---05-March-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/blob/HEAD/CHANGELOG.md#103---11-February-2022)
[Compare Source](https://togithub.com/knex/knex/compare/8fd1f22d2e9ccdd1d98d874d64a255858906d854...1.0.3)
##### Bug fixes:
- Fix error message for missing migration files [#4937](https://togithub.com/knex/knex/issues/4937)
- Add withMaterialized and withNotMaterialized to method-constants [#5009](https://togithub.com/knex/knex/issues/5009)
- PostgreSQL: Fix whereJsonPath queries [#5011](https://togithub.com/knex/knex/issues/5011)
- PostgreSQL: Fix delete joins [#5016](https://togithub.com/knex/knex/issues/5016)
- CockroachDB: Fix whereJsonPath queries [#5011](https://togithub.com/knex/knex/issues/5011)
- MySQL: Create primary keys in same statement [#5017](https://togithub.com/knex/knex/issues/5017)
##### Typings:
- Fix type definition for getMigration in MigrationSource [#4998](https://togithub.com/knex/knex/issues/4998)
- Fix argument type of alter method [#4996](https://togithub.com/knex/knex/issues/4996)
##### Improvements:
- Use async / await syntax in seeds as default [#5005](https://togithub.com/knex/knex/issues/5005)
##### Documentation:
- Add Firebird dialect to ECOSYSTEM.md [#5003](https://togithub.com/knex/knex/issues/5003)
### [`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)
### [`v0.21.18`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02118---22-February-2021)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.17...d2f8a1b1d5d48a6e668f1fab39c08ce76daf587c)
- 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)
### [`v0.21.17`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02117---30-January-2021)
[Compare Source](https://togithub.com/knex/knex/compare/b2608569b4245d114248fa0e5bb0b328410ab717...0.21.17)
##### Bug fixes:
- SQLite: Fix SQLite foreign on delete when altering a table [#4261](https://togithub.com/knex/knex/issues/4261)
##### New features:
- Add support for optimizer hints (see [https://github.com/knex/documentation/pull/306](https://togithub.com/knex/documentation/pull/306) for documentation) [#4243](https://togithub.com/knex/knex/issues/4243)
### [`v0.21.16`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02116---17-January-2021)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.15...b2608569b4245d114248fa0e5bb0b328410ab717)
##### Bug fixes:
- MSSQL: Avoid passing unsupported pool param. Fixes node-mssql 7+ support [#4236](https://togithub.com/knex/knex/issues/4236)
### [`v0.21.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02115---26-December-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.14...0.21.15)
##### New features:
- SQLite: Add primary/foreign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162)
- SQLite: Add dropPrimary/dropForeign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162)
##### Typings:
- Add "after" and "first" to columnBuilder types [#3549](https://togithub.com/knex/knex/issues/3549) [#4169](https://togithub.com/knex/knex/issues/4169)
##### Test / internal changes:
- Extract knex config resolution logic [#4166](https://togithub.com/knex/knex/issues/4166)
- Run CI using GitHub Actions [#4168](https://togithub.com/knex/knex/issues/4168)
- Add Node.js 15 to CI matrix [#4173](https://togithub.com/knex/knex/issues/4173)
### [`v0.21.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02114---18-December-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.13...0.21.14)
##### New features:
- MSSQL: support "returning" on inserts, updates and deletes on tables with triggers [#4152](https://togithub.com/knex/knex/issues/4152)
- Use esm import if package.json type is "module" [#4158](https://togithub.com/knex/knex/issues/4158)
##### Bug fixes:
- Make sure query-response and query-error events contain \_knexTxId [#4160](https://togithub.com/knex/knex/issues/4160)
##### Test / internal changes:
- Improved integration test framework [#4161](https://togithub.com/knex/knex/issues/4161)
### [`v0.21.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02113---12-December-2020)
[Compare Source](https://togithub.com/knex/knex/compare/90b145dc84b1281b985fa5cedd09b8cb362add9e...0.21.13)
##### New features:
- SQLite: Add support for `dropForeign` [#4092](https://togithub.com/knex/knex/issues/4092)
- Add support for WHERE clauses to "upsert" queries [#4148](https://togithub.com/knex/knex/issues/4148)
##### Bug fixes:
- MSSQL: Avoid connection getting stuck on socket hangup [#4157](https://togithub.com/knex/knex/issues/4157)
- Oracle: Support specifying non-default DB port [#4147](https://togithub.com/knex/knex/issues/4147)
- Oracle: Support inserts with only default values (empty body) [#4092](https://togithub.com/knex/knex/issues/4092)
- CLI: fix irregular seed file execution order [#4156](https://togithub.com/knex/knex/issues/4156)
- Fix performance of asyncStackTraces with enable-source-maps node flag [#4154](https://togithub.com/knex/knex/issues/4154)
##### Typings:
- PostgreSQL: Add support for application_name [#4153](https://togithub.com/knex/knex/issues/4153)
- Fix types for insert to allow array [#4105](https://togithub.com/knex/knex/issues/4105)
- Add types for userParams and withUserParams [#4119](https://togithub.com/knex/knex/issues/4119)
- Added type for withKeyName [#4139](https://togithub.com/knex/knex/issues/4139)
- Fix batchInsert definitions [#4131](https://togithub.com/knex/knex/issues/4131)
- Fix types for WhereIn signature (value or query builder) [#3863](https://togithub.com/knex/knex/issues/3863)
- Add types for connection config of mysql2 driver [#4144](https://togithub.com/knex/knex/issues/4144)
##### Test / internal changes:
- Move TS tests to tsd (WIP) [#4109](https://togithub.com/knex/knex/issues/4109) [#4110](https://togithub.com/knex/knex/issues/4110)
### [`v0.21.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02112---02-November-2020)
[Compare Source](https://togithub.com/knex/knex/compare/4cfb3ea17b8580d370f096807b7f8954a32a5f89...90b145dc84b1281b985fa5cedd09b8cb362add9e)
##### Typings:
- Reintroduce support for globally defining table/record mapping [#4100](https://togithub.com/knex/knex/issues/4100)
- Add a few missing types for MSSQL Connection [#4103](https://togithub.com/knex/knex/issues/4103)
- Make .ignore() and .merge() return QueryBuilder rather than QueryInterface [#4102](https://togithub.com/knex/knex/issues/4102)
- Use tarn config TS types instead of generic-pool [#4064](https://togithub.com/knex/knex/issues/4064)
### [`v0.21.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02111---01-November-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.10...4cfb3ea17b8580d370f096807b7f8954a32a5f89)
##### Typings:
- Revert support for globally defining table/record mapping [#4099](https://togithub.com/knex/knex/issues/4099)
### [`v0.21.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02110---31-October-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.9...0.21.10)
##### New features:
- Upsert support (Postgres/MySQL/Sqlite) [#3763](https://togithub.com/knex/knex/issues/3763)
##### Bug fixes:
- Switch to non-uuid knexQueryUids to avoid issues when mocking global date [#4089](https://togithub.com/knex/knex/issues/4089)
##### Typings:
- Allow to globally define table/record mapping [#4071](https://togithub.com/knex/knex/issues/4071)
### [`v0.21.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0219---27-October-2020)
[Compare Source](https://togithub.com/knex/knex/compare/2bcaf51f9d025c9c8631e357da16e3cb3224792c...0.21.9)
##### New features:
- add method clear(statement) to QueryBuilder [#4051](https://togithub.com/knex/knex/issues/4051)
##### Bug fixes:
- CLI: fix help text being printed twice [#4072](https://togithub.com/knex/knex/issues/4072)
- Oracle: columnInfo() no longer requires an Owner User [#4053](https://togithub.com/knex/knex/issues/4053)
- Add missing "start" event propagation from transaction [#4087](https://togithub.com/knex/knex/issues/4087)
### [`v0.21.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0218---27-October-2020)
[Compare Source](https://togithub.com/knex/knex/compare/23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed...2bcaf51f9d025c9c8631e357da16e3cb3224792c)
##### Bug fixes:
- MSSQL: Escape properly if literal '?' is needed [#4053](https://togithub.com/knex/knex/issues/4053)
- Make toQuery behavior consistent with pre-0.21.7 (do not break on empty builder) [#4083](https://togithub.com/knex/knex/issues/4083)
- Fix comment escaping for MySQL and PostgreSQL [#4084](https://togithub.com/knex/knex/issues/4084)
### [`v0.21.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0217---25-October-2020)
[Compare Source](https://togithub.com/knex/knex/compare/7cfb78d16aa9dcd635c9ae1862837ccd4f507a21...23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed)
##### New features:
- CLI: Add migration stub for .cjs extension [#4065](https://togithub.com/knex/knex/issues/4065)
##### Bug fixes:
- MSSQL: Add dynamic scaling for decimal values and prevents a UInt64 overflow [#3910](https://togithub.com/knex/knex/issues/3910)
- MSSQL: Fix apostrophe escaping [#4077](https://togithub.com/knex/knex/issues/4077)
- Ensure that semicolon is not appended to statements that already end with a semicolon [#4052](https://togithub.com/knex/knex/issues/4052)
##### Typings:
- Add arguments to QueryCallback in Where [#4034](https://togithub.com/knex/knex/issues/4034)
##### Test / internal changes:
- Replace lodash type-checks with native solutions [#4056](https://togithub.com/knex/knex/issues/4056)
- Replace mkdirp with native recursive flag [#4060](https://togithub.com/knex/knex/issues/4060)
- Replace inherits package with builtin utility [#4059](https://togithub.com/knex/knex/issues/4059)
### [`v0.21.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0216---27-September-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.5...7cfb78d16aa9dcd635c9ae1862837ccd4f507a21)
##### New features:
- CLI: New config parameter / CLI flag to prefixing seed filename with timestamp [#3873](https://togithub.com/knex/knex/issues/3873)
- CLI: throw an error when specific seed file cannot be found [#4011](https://togithub.com/knex/knex/issues/4011)
- Warn if whereNot is used with 'in' or 'between' [#4038](https://togithub.com/knex/knex/issues/4038)
##### Bug fixes:
- CLI: Fix double merging of config for migrator [#4040](https://togithub.com/knex/knex/issues/4040)
##### Typings:
- Unify SeedsConfig and SeederConfig [#4003](https://togithub.com/knex/knex/issues/4003)
- Allow string\[] type for directory in SeedsConfig [#4033](https://togithub.com/knex/knex/issues/4033)
### [`v0.21.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0215---17-August-2020)
[Compare Source](https://togithub.com/knex/knex/compare/b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b...0.21.5)
##### New features:
- CLI: Improve Esm interop [#3985](https://togithub.com/knex/knex/issues/3985)
- CLI: Improve mjs module support [#3980](https://togithub.com/knex/knex/issues/3980)
##### Test / internal changes:
- Bump version of dtslint [#3984](https://togithub.com/knex/knex/issues/3984)
- Test/document esm interop mixed formats (knexfile/migrations/seeds) [#3986](https://togithub.com/knex/knex/issues/3986)
### [`v0.21.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0214---10-August-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.3...b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b)
##### New features:
- CLI: Add new option for seed: recursive [#3974](https://togithub.com/knex/knex/issues/3974)
##### Bug fixes:
- CLI: Do not load seeds from subfolders recursively by default [#3974](https://togithub.com/knex/knex/issues/3974)
### [`v0.21.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0213---08-August-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.2...0.21.3)
##### New features:
- CLI: Support multiple directories for seeds [#3967](https://togithub.com/knex/knex/issues/3967)
##### Bug fixes:
- Ensure DB stream is destroyed when the PassThrough is destroyed [#2324](https://togithub.com/knex/knex/issues/2324)
- Support postProcessResponse for streams [#3931](https://togithub.com/knex/knex/issues/3931)
- Fix ESM module interop for calling module/package of type 'module' [#3938](https://togithub.com/knex/knex/issues/3938)
- CLI: Fix migration source name in rollback all [#3956](https://togithub.com/knex/knex/issues/3956)
- Fix getMergedConfig calls to include client logger [#3920](https://togithub.com/knex/knex/issues/3920)
- Escape single quoted values passed to defaultTo function [#3899](https://togithub.com/knex/knex/issues/3899)
##### Typings:
- Add .timeout(ms) to .raw()'s typescript typings [#3885](https://togithub.com/knex/knex/issues/3885)
- Add typing for double table column builder [#3950](https://togithub.com/knex/knex/issues/3950)
- Add a phantom tag to Ref type to mark received type parameters as used [#3934](https://togithub.com/knex/knex/issues/3934)
- Add `null` as valid binding type [#3946](https://togithub.com/knex/knex/issues/3946)
##### Test / internal changes:
- Change query lab link to https [#3933](https://togithub.com/knex/knex/issues/3933)
### [`v0.21.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0212---10-July-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.1...0.21.2)
##### New features:
- Warn user if custom migration source is being reset [#3839](https://togithub.com/knex/knex/issues/3839)
- Prefer `void` as return type on migration generator ts stub [#3865](https://togithub.com/knex/knex/issues/3865)
- MSSQL: Added the removal of a columns default constraint, before dropping the column [#3855](https://togithub.com/knex/knex/issues/3855)
##### Typings:
- Fix definition for raw querybuilders [#3846](https://togithub.com/knex/knex/issues/3846)
##### Test / internal changes:
- Refactor migration logic to use async/await [#3838](https://togithub.com/knex/knex/issues/3838)
### [`v0.21.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02119---02-March-2021)
[Compare Source](https://togithub.com/knex/knex/compare/0.21.0...0.21.1)
- SQLite: Made the constraint detection case-insensitive [#4332](https://togithub.com/knex/knex/issues/4332)
### [`v0.21.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0210---18-April-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.15...0.21.0)
##### Improvements
- Reduce size of lodash in bundle [#3804](https://togithub.com/knex/knex/issues/3804)
##### Breaking changes
- Dropped support for Node 8
- Breaking upstream change in `pg-query-stream`: `Changed stream.close to stream.destroy which is the official way to terminate a readable stream. This is a breaking change if you rely on the stream.close method on pg-query-stream...though should be just a find/replace type operation to upgrade as the semantics remain very similar (not exactly the same, since internals are rewritten, but more in line with how streams are "supposed" to behave).`
##### Test / internal changes:
- Updated Tarn.js to a version 3.0.0
- Updated mkdirp to a version 1.0.4
- Updated examples to use ES2015 style [#3810](https://togithub.com/knex/knex/issues/3810)
### [`v0.20.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02015---16-April-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.14...0.20.15)
##### Bug fixes:
- Support for `.finally(..)` on knex's Promise-alikes [#3800](https://togithub.com/knex/knex/issues/3800)
##### Typings:
- Add types for `.distinctOn` [#3784](https://togithub.com/knex/knex/issues/3784)
### [`v0.20.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02014---13-April-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.13...0.20.14)
##### New features:
- CLI: adds support for asynchronous knexfile loading [#3748](https://togithub.com/knex/knex/issues/3748)
- Add clearGroup method [#3771](https://togithub.com/knex/knex/issues/3771)
##### Typings:
- Support Raw types for insert, where, update [#3730](https://togithub.com/knex/knex/issues/3730)
- Add typings for MigrationSource [#3756](https://togithub.com/knex/knex/issues/3756)
- Update signature of orderBy to support QueryBuilder inside array [#3757](https://togithub.com/knex/knex/issues/3757)
- Add toSQL and toString to SchemaBuilder [#3758](https://togithub.com/knex/knex/issues/3758)
- `interface Knex` and `function Knex` should have the same types [#3787](https://togithub.com/knex/knex/issues/3787)
- Fix minor issues around typings [#3765](https://togithub.com/knex/knex/issues/3765)
##### Test / internal changes:
- Minor test internal enhancements [#3747](https://togithub.com/knex/knex/issues/3747)
- Minor improvements on the usage of fs utilities [#3749](https://togithub.com/knex/knex/issues/3749)
- Split tests in groups [#3785](https://togithub.com/knex/knex/issues/3785)
### [`v0.20.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02013---23-March-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.12...0.20.13)
##### Bug fixes:
- Correctly handle dateToString escaping without timezone passed [#3742](https://togithub.com/knex/knex/issues/3742)
- Make protocol length check more defensive [#3744](https://togithub.com/knex/knex/issues/3744)
##### Typings:
- Make the ChainableInterface conform to Promise [#3724](https://togithub.com/knex/knex/issues/3724)
### [`v0.20.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02012---19-March-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.11...0.20.12)
##### Bug fixes:
- Added missing call to \_reject in Transactor#transaction [#3706](https://togithub.com/knex/knex/issues/3706)
- Fix method binding on knex proxy [#3717](https://togithub.com/knex/knex/issues/3717)
- Oracle: Transaction_OracleDB can use config.connection [#3731](https://togithub.com/knex/knex/issues/3731)
##### Typings:
- Fix incorrect type signature of Having [#3719](https://togithub.com/knex/knex/issues/3719)
##### Test / internal changes:
- Cleanup/remove transaction stalling [#3716](https://togithub.com/knex/knex/issues/3716)
- Rewrote Transaction#acquireConnection() methods to use async [#3707](https://togithub.com/knex/knex/issues/3707)
### [`v0.20.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02011---26-February-2020)
[Compare Source](https://togithub.com/knex/knex/compare/72886086b65583b395d2c34851ef60a5a6d5fd75...0.20.11)
##### Breaking changes:
- Knex returns native JS promises instead of Bluebird ones. This means that you no longer use such methods as `map`, `spread` and `reduce` on QueryBuilder instance.
##### New features:
- Oracle: Add OracleDB handling for buffer type in fetchAsString [#3685](https://togithub.com/knex/knex/issues/3685)
##### Bug fixes:
- Fix race condition in non-container transactions [#3671](https://togithub.com/knex/knex/issues/3671)
##### Typings:
- Mark knex arguments of composite/collection types to be readonly [#3680](https://togithub.com/knex/knex/issues/3680)
##### Test / internal changes:
- Remove dependency on Bluebird methods from sources [#3683](https://togithub.com/knex/knex/issues/3683)
- Cleanup and extract Transaction Workflow logic [#3674](https://togithub.com/knex/knex/issues/3674)
### [`v0.20.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02010---13-February-2020)
[Compare Source](https://togithub.com/knex/knex/compare/92d394432cef729d1b434a898e27163677c72b07...72886086b65583b395d2c34851ef60a5a6d5fd75)
##### Bug fixes:
- Oracle: commit was a no-op causing race conditions [#3668](https://togithub.com/knex/knex/issues/3668)
- CLI: Knex calls process.chdir() before opening Knexfile [#3661](https://togithub.com/knex/knex/issues/3661)
- Fixed unresolved promise in cancelQuery() [#3666](https://togithub.com/knex/knex/issues/3666)
##### Typings:
- `fn.now` takes optionally a precision argument. [#3662](https://togithub.com/knex/knex/issues/3662)
- PG: Include SSL in connection definition [#3659](https://togithub.com/knex/knex/issues/3659)
##### Test / internal changes:
- replace Bluebird.timeout [#3634](https://togithub.com/knex/knex/issues/3634)
### [`v0.20.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0209---08-February-2020)
[Compare Source](https://togithub.com/knex/knex/compare/faacfd726ea4c6ff809758edf88c2c0154af7717...92d394432cef729d1b434a898e27163677c72b07)
##### Bug fixes:
- CLI: Improve Support for Liftoff's Preloaders - this should fix some cases like using TS for your migrations [#3613](https://togithub.com/knex/knex/issues/3613)
##### Typings:
- MSSQL: Add `enableArithAbort` to `MsSqlConnectionConfig`
##### Test / internal changes:
- Refactor more tests to use cli-testlab [#3640](https://togithub.com/knex/knex/issues/3640)
- Update QueryCompiler implementation to use classes [#3647](https://togithub.com/knex/knex/issues/3647)
### [`v0.20.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0208---14-January-2020)
[Compare Source](https://togithub.com/knex/knex/compare/2e3c7fe231b6c43238979613f5788e5c49578d30...faacfd726ea4c6ff809758edf88c2c0154af7717)
##### New features:
- CLI: Support ES6 modules via flag --esm [#3616](https://togithub.com/knex/knex/issues/3616)
##### Bug fixes:
- CLI: Print help only when there are no arguments [#3617](https://togithub.com/knex/knex/issues/3617)
##### Typings:
- Fix incorrect type of QueryBuilder.first('\*') result [#3621](https://togithub.com/knex/knex/issues/3621)
### [`v0.20.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0207---07-January-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.6...2e3c7fe231b6c43238979613f5788e5c49578d30)
##### New features:
- Throw better error when trying to modify schema while using unsupported dialect [#3609](https://togithub.com/knex/knex/issues/3609)
##### Bug fixes:
- Oracle: dispose connection on connection error [#3611](https://togithub.com/knex/knex/issues/3611)
- Oracle: fix not releasing connection from pool on disconnect [#3605](https://togithub.com/knex/knex/issues/3605)
- CLI: prevent warning with root command [#3604](https://togithub.com/knex/knex/issues/3604)
##### Typings:
- Add create/drop schema methods to SchemaBuilder [#3579](https://togithub.com/knex/knex/issues/3579)
### [`v0.20.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0206---29-December-2019)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.4...0.20.6)
##### Bug fixes:
- Enforce Unix (lf) line terminators [#3598](https://togithub.com/knex/knex/issues/3598)
### [`v0.20.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0204---08-December-2019)
[Compare Source](https://togithub.com/knex/knex/compare/ea0633281d786ab62ea37ae0511776563eba952a...0.20.4)
##### Bug fixes:
- Fix debug logger messing up queries with % [#3566](https://togithub.com/knex/knex/issues/3566)
- Make logger methods mutually consistent [#3567](https://togithub.com/knex/knex/issues/3567)
##### Typings:
- Add missing methods to client type [#3565](https://togithub.com/knex/knex/issues/3565)
- Fix queryContext function defintion [#3562](https://togithub.com/knex/knex/issues/3562)
- Fix QueryBuilder.extend this type [#3526](https://togithub.com/knex/knex/issues/3526) [#3528](https://togithub.com/knex/knex/issues/3528)
##### Test / internal changes:
- Remove bluebird.using [#3552](https://togithub.com/knex/knex/issues/3552)
### [`v0.20.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0203---27-November-2019)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.2...ea0633281d786ab62ea37ae0511776563eba952a)
##### New features:
- MSSQL, MySQL: Add connection string qs to connection params [#3547](https://togithub.com/knex/knex/issues/3547)
##### Bug fixes:
- Oracle: Fix issue retrieving BLOB from database [#3545](https://togithub.com/knex/knex/issues/3545)
- PostgreSQL: Timeout for postgresql use cancel instead of terminate [#3518](https://togithub.com/knex/knex/issues/3518)
- Make sure CLI works for namespaced knex packages [#2539](https://togithub.com/knex/knex/issues/2539)
##### Typings:
- Lift up dialect specific methods in the CreateTableBuilder [#3532](https://togithub.com/knex/knex/issues/3532)
- Add client property to QueryBuilder type [#3541](https://togithub.com/knex/knex/issues/3541)
- Support 'only' option [#3551](https://togithub.com/knex/knex/issues/3551)
### [`v0.20.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0202---14-November-2019)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.1...0.20.2)
##### New features:
- Add support for distinct on for postgres [#3513](https://togithub.com/knex/knex/issues/3513)
##### Bug fixes:
- Make sqlite3 hasColumn case insensitive [#3435](https://togithub.com/knex/knex/issues/3435)
##### Typings:
- Fix PoolConfig typing [#3505](https://togithub.com/knex/knex/issues/3505)
- Expand SeedsConfig types [#3531](https://togithub.com/knex/knex/issues/3531)
- Make the default type parameters of QueryBuilder less strict [#3520](https://togithub.com/knex/knex/issues/3520)
- Fix regression in older version of node when Promise#finally was not available [#3507](https://togithub.com/knex/knex/issues/3507)
### [`v0.20.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02015---16-April-2020)
[Compare Source](https://togithub.com/knex/knex/compare/0.20.0...0.20.1)
##### Bug fixes:
- Support for `.finally(..)` on knex's Promise-alikes [#3800](https://togithub.com/knex/knex/issues/3800)
##### Typings:
- Add types for `.distinctOn` [#3784](https://togithub.com/knex/knex/issues/3784)
### [`v0.20.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0200---25-October-2019)
[Compare Source](https://togithub.com/knex/knex/compare/0.19.5...0.20.0)
##### New features:
- orderBy accepts QueryBuilder [#3491](https://togithub.com/knex/knex/issues/3491)
- Add validation in `.offset()` [#2908](https://togithub.com/knex/knex/issues/2908)
- disable_migrations_list_validation feature [#3448](https://togithub.com/knex/knex/issues/3448)
##### Bug fixes:
- Fix oracledb driver v4 support [#3480](https://togithub.com/knex/knex/issues/3480)
- Fix some issues around seed and migration generation [#3479](https://togithub.com/knex/knex/issues/3479)
- Fix bugs in replacement logic used when dropping columns in SQLite [#3476](https://togithub.com/knex/knex/issues/3476)
##### Typings:
- Add types to the Migrator interface [#3459](https://togithub.com/knex/knex/issues/3459)
- Fix typings of index and dropIndex TableBuilder methods [#3486](https://togithub.com/knex/knex/issues/3486)
- Fixes types for Seeder#run [#3438](https://togithub.com/knex/knex/issues/3438)
##### Test / internal changes:
- Execute CI on Node.js 13
- Bluebird: remove usage of `return`, `reflect`, `fromCallback` methods [#3483](https://togithub.com/knex/knex/issues/3483)
- Bluebird: remove Bluebird.bind [#3477](https://togithub.com/knex/knex/issues/3477)
- Bluebird: use util.promisify instead of Bluebird.promisify [#3470](https://togithub.com/knex/knex/issues/3470)
- Bluebird: remove Bluebird.each [#3471](https://togithub.com/knex/knex/issues/3471)
- Bluebird: remove Bluebird.map and Bluebird.mapSeries [#3474](https://togithub.com/knex/knex/issues/3474)
- Bluebird: replace Bluebird.map with Promise.all [#3469](https://togithub.com/knex/knex/issues/3469)
- Update badges [#3482](https://togithub.com/knex/knex/issues/3482)
### [`v0.19.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0195---06-October-2019)
[Compare Source](https://togithub.com/knex/knex/compare/65969d60f72ffef7cc7e093e00af1a5d34908e2f...0.19.5)
##### New features:
- CLI: Migrations up/down commands - filename parameter [#3416](https://togithub.com/knex/knex/issues/3416)
- Oracle: Support stored procedures [#3449](https://togithub.com/knex/knex/issues/3449)
##### Bug fixes:
- MSSQL: Escape column ids correctly in all cases (reported by Snyk Security Research Team) [#3382](https://togithub.com/knex/knex/issues/3382)
- SQLite: Fix handling of multiline SQL in SQLite3 schema [#3411](https://togithub.com/knex/knex/issues/3411)
- Fix concurrent child transactions failing [#2213](https://togithub.com/knex/knex/issues/2213) [#3440](https://togithub.com/knex/knex/issues/3440)
##### Typings:
- Add missing Migrator.list typing [#3460](https://togithub.com/knex/knex/issues/3460)
- Fix Typescript type inference for to better support wildcard (\*) calls [#3444](https://togithub.com/knex/knex/issues/3444)
- Make options argument optional in timeout [#3442](https://togithub.com/knex/knex/issues/3442)
##### Test / internal changes:
- Enable linting in CI [#3450](https://togithub.com/knex/knex/issues/3450)
### [`v0.19.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0194---09-September-2019)
[Compare Source](https://togithub.com/knex/knex/compare/0.19.3..
Configuration
📅 Schedule: "before 2pm on Tuesday,before 2pm on Friday" in timezone Europe/Stockholm.
🚦 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.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
^0.15.2
->^1.0.0
Release Notes
knex/knex
### [`v1.0.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#105---05-March-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/blob/HEAD/CHANGELOG.md#103---11-February-2022) [Compare Source](https://togithub.com/knex/knex/compare/8fd1f22d2e9ccdd1d98d874d64a255858906d854...1.0.3) ##### Bug fixes: - Fix error message for missing migration files [#4937](https://togithub.com/knex/knex/issues/4937) - Add withMaterialized and withNotMaterialized to method-constants [#5009](https://togithub.com/knex/knex/issues/5009) - PostgreSQL: Fix whereJsonPath queries [#5011](https://togithub.com/knex/knex/issues/5011) - PostgreSQL: Fix delete joins [#5016](https://togithub.com/knex/knex/issues/5016) - CockroachDB: Fix whereJsonPath queries [#5011](https://togithub.com/knex/knex/issues/5011) - MySQL: Create primary keys in same statement [#5017](https://togithub.com/knex/knex/issues/5017) ##### Typings: - Fix type definition for getMigration in MigrationSource [#4998](https://togithub.com/knex/knex/issues/4998) - Fix argument type of alter method [#4996](https://togithub.com/knex/knex/issues/4996) ##### Improvements: - Use async / await syntax in seeds as default [#5005](https://togithub.com/knex/knex/issues/5005) ##### Documentation: - Add Firebird dialect to ECOSYSTEM.md [#5003](https://togithub.com/knex/knex/issues/5003) ### [`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) ### [`v0.21.18`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02118---22-February-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.17...d2f8a1b1d5d48a6e668f1fab39c08ce76daf587c) - 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) ### [`v0.21.17`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02117---30-January-2021) [Compare Source](https://togithub.com/knex/knex/compare/b2608569b4245d114248fa0e5bb0b328410ab717...0.21.17) ##### Bug fixes: - SQLite: Fix SQLite foreign on delete when altering a table [#4261](https://togithub.com/knex/knex/issues/4261) ##### New features: - Add support for optimizer hints (see [https://github.com/knex/documentation/pull/306](https://togithub.com/knex/documentation/pull/306) for documentation) [#4243](https://togithub.com/knex/knex/issues/4243) ### [`v0.21.16`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02116---17-January-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.15...b2608569b4245d114248fa0e5bb0b328410ab717) ##### Bug fixes: - MSSQL: Avoid passing unsupported pool param. Fixes node-mssql 7+ support [#4236](https://togithub.com/knex/knex/issues/4236) ### [`v0.21.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02115---26-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.14...0.21.15) ##### New features: - SQLite: Add primary/foreign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162) - SQLite: Add dropPrimary/dropForeign support on alterTable [#4162](https://togithub.com/knex/knex/issues/4162) ##### Typings: - Add "after" and "first" to columnBuilder types [#3549](https://togithub.com/knex/knex/issues/3549) [#4169](https://togithub.com/knex/knex/issues/4169) ##### Test / internal changes: - Extract knex config resolution logic [#4166](https://togithub.com/knex/knex/issues/4166) - Run CI using GitHub Actions [#4168](https://togithub.com/knex/knex/issues/4168) - Add Node.js 15 to CI matrix [#4173](https://togithub.com/knex/knex/issues/4173) ### [`v0.21.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02114---18-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.13...0.21.14) ##### New features: - MSSQL: support "returning" on inserts, updates and deletes on tables with triggers [#4152](https://togithub.com/knex/knex/issues/4152) - Use esm import if package.json type is "module" [#4158](https://togithub.com/knex/knex/issues/4158) ##### Bug fixes: - Make sure query-response and query-error events contain \_knexTxId [#4160](https://togithub.com/knex/knex/issues/4160) ##### Test / internal changes: - Improved integration test framework [#4161](https://togithub.com/knex/knex/issues/4161) ### [`v0.21.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02113---12-December-2020) [Compare Source](https://togithub.com/knex/knex/compare/90b145dc84b1281b985fa5cedd09b8cb362add9e...0.21.13) ##### New features: - SQLite: Add support for `dropForeign` [#4092](https://togithub.com/knex/knex/issues/4092) - Add support for WHERE clauses to "upsert" queries [#4148](https://togithub.com/knex/knex/issues/4148) ##### Bug fixes: - MSSQL: Avoid connection getting stuck on socket hangup [#4157](https://togithub.com/knex/knex/issues/4157) - Oracle: Support specifying non-default DB port [#4147](https://togithub.com/knex/knex/issues/4147) - Oracle: Support inserts with only default values (empty body) [#4092](https://togithub.com/knex/knex/issues/4092) - CLI: fix irregular seed file execution order [#4156](https://togithub.com/knex/knex/issues/4156) - Fix performance of asyncStackTraces with enable-source-maps node flag [#4154](https://togithub.com/knex/knex/issues/4154) ##### Typings: - PostgreSQL: Add support for application_name [#4153](https://togithub.com/knex/knex/issues/4153) - Fix types for insert to allow array [#4105](https://togithub.com/knex/knex/issues/4105) - Add types for userParams and withUserParams [#4119](https://togithub.com/knex/knex/issues/4119) - Added type for withKeyName [#4139](https://togithub.com/knex/knex/issues/4139) - Fix batchInsert definitions [#4131](https://togithub.com/knex/knex/issues/4131) - Fix types for WhereIn signature (value or query builder) [#3863](https://togithub.com/knex/knex/issues/3863) - Add types for connection config of mysql2 driver [#4144](https://togithub.com/knex/knex/issues/4144) ##### Test / internal changes: - Move TS tests to tsd (WIP) [#4109](https://togithub.com/knex/knex/issues/4109) [#4110](https://togithub.com/knex/knex/issues/4110) ### [`v0.21.12`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02112---02-November-2020) [Compare Source](https://togithub.com/knex/knex/compare/4cfb3ea17b8580d370f096807b7f8954a32a5f89...90b145dc84b1281b985fa5cedd09b8cb362add9e) ##### Typings: - Reintroduce support for globally defining table/record mapping [#4100](https://togithub.com/knex/knex/issues/4100) - Add a few missing types for MSSQL Connection [#4103](https://togithub.com/knex/knex/issues/4103) - Make .ignore() and .merge() return QueryBuilder rather than QueryInterface [#4102](https://togithub.com/knex/knex/issues/4102) - Use tarn config TS types instead of generic-pool [#4064](https://togithub.com/knex/knex/issues/4064) ### [`v0.21.11`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02111---01-November-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.10...4cfb3ea17b8580d370f096807b7f8954a32a5f89) ##### Typings: - Revert support for globally defining table/record mapping [#4099](https://togithub.com/knex/knex/issues/4099) ### [`v0.21.10`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02110---31-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.9...0.21.10) ##### New features: - Upsert support (Postgres/MySQL/Sqlite) [#3763](https://togithub.com/knex/knex/issues/3763) ##### Bug fixes: - Switch to non-uuid knexQueryUids to avoid issues when mocking global date [#4089](https://togithub.com/knex/knex/issues/4089) ##### Typings: - Allow to globally define table/record mapping [#4071](https://togithub.com/knex/knex/issues/4071) ### [`v0.21.9`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0219---27-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/2bcaf51f9d025c9c8631e357da16e3cb3224792c...0.21.9) ##### New features: - add method clear(statement) to QueryBuilder [#4051](https://togithub.com/knex/knex/issues/4051) ##### Bug fixes: - CLI: fix help text being printed twice [#4072](https://togithub.com/knex/knex/issues/4072) - Oracle: columnInfo() no longer requires an Owner User [#4053](https://togithub.com/knex/knex/issues/4053) - Add missing "start" event propagation from transaction [#4087](https://togithub.com/knex/knex/issues/4087) ### [`v0.21.8`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0218---27-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed...2bcaf51f9d025c9c8631e357da16e3cb3224792c) ##### Bug fixes: - MSSQL: Escape properly if literal '?' is needed [#4053](https://togithub.com/knex/knex/issues/4053) - Make toQuery behavior consistent with pre-0.21.7 (do not break on empty builder) [#4083](https://togithub.com/knex/knex/issues/4083) - Fix comment escaping for MySQL and PostgreSQL [#4084](https://togithub.com/knex/knex/issues/4084) ### [`v0.21.7`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0217---25-October-2020) [Compare Source](https://togithub.com/knex/knex/compare/7cfb78d16aa9dcd635c9ae1862837ccd4f507a21...23073fa83dfb4bf0ecb204c9ae1f720cd22f41ed) ##### New features: - CLI: Add migration stub for .cjs extension [#4065](https://togithub.com/knex/knex/issues/4065) ##### Bug fixes: - MSSQL: Add dynamic scaling for decimal values and prevents a UInt64 overflow [#3910](https://togithub.com/knex/knex/issues/3910) - MSSQL: Fix apostrophe escaping [#4077](https://togithub.com/knex/knex/issues/4077) - Ensure that semicolon is not appended to statements that already end with a semicolon [#4052](https://togithub.com/knex/knex/issues/4052) ##### Typings: - Add arguments to QueryCallback in Where [#4034](https://togithub.com/knex/knex/issues/4034) ##### Test / internal changes: - Replace lodash type-checks with native solutions [#4056](https://togithub.com/knex/knex/issues/4056) - Replace mkdirp with native recursive flag [#4060](https://togithub.com/knex/knex/issues/4060) - Replace inherits package with builtin utility [#4059](https://togithub.com/knex/knex/issues/4059) ### [`v0.21.6`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0216---27-September-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.5...7cfb78d16aa9dcd635c9ae1862837ccd4f507a21) ##### New features: - CLI: New config parameter / CLI flag to prefixing seed filename with timestamp [#3873](https://togithub.com/knex/knex/issues/3873) - CLI: throw an error when specific seed file cannot be found [#4011](https://togithub.com/knex/knex/issues/4011) - Warn if whereNot is used with 'in' or 'between' [#4038](https://togithub.com/knex/knex/issues/4038) ##### Bug fixes: - CLI: Fix double merging of config for migrator [#4040](https://togithub.com/knex/knex/issues/4040) ##### Typings: - Unify SeedsConfig and SeederConfig [#4003](https://togithub.com/knex/knex/issues/4003) - Allow string\[] type for directory in SeedsConfig [#4033](https://togithub.com/knex/knex/issues/4033) ### [`v0.21.5`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0215---17-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b...0.21.5) ##### New features: - CLI: Improve Esm interop [#3985](https://togithub.com/knex/knex/issues/3985) - CLI: Improve mjs module support [#3980](https://togithub.com/knex/knex/issues/3980) ##### Test / internal changes: - Bump version of dtslint [#3984](https://togithub.com/knex/knex/issues/3984) - Test/document esm interop mixed formats (knexfile/migrations/seeds) [#3986](https://togithub.com/knex/knex/issues/3986) ### [`v0.21.4`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0214---10-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.3...b2e3c5c4d9d3c587e4f3602e8ddd07096cdab46b) ##### New features: - CLI: Add new option for seed: recursive [#3974](https://togithub.com/knex/knex/issues/3974) ##### Bug fixes: - CLI: Do not load seeds from subfolders recursively by default [#3974](https://togithub.com/knex/knex/issues/3974) ### [`v0.21.3`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0213---08-August-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.2...0.21.3) ##### New features: - CLI: Support multiple directories for seeds [#3967](https://togithub.com/knex/knex/issues/3967) ##### Bug fixes: - Ensure DB stream is destroyed when the PassThrough is destroyed [#2324](https://togithub.com/knex/knex/issues/2324) - Support postProcessResponse for streams [#3931](https://togithub.com/knex/knex/issues/3931) - Fix ESM module interop for calling module/package of type 'module' [#3938](https://togithub.com/knex/knex/issues/3938) - CLI: Fix migration source name in rollback all [#3956](https://togithub.com/knex/knex/issues/3956) - Fix getMergedConfig calls to include client logger [#3920](https://togithub.com/knex/knex/issues/3920) - Escape single quoted values passed to defaultTo function [#3899](https://togithub.com/knex/knex/issues/3899) ##### Typings: - Add .timeout(ms) to .raw()'s typescript typings [#3885](https://togithub.com/knex/knex/issues/3885) - Add typing for double table column builder [#3950](https://togithub.com/knex/knex/issues/3950) - Add a phantom tag to Ref type to mark received type parameters as used [#3934](https://togithub.com/knex/knex/issues/3934) - Add `null` as valid binding type [#3946](https://togithub.com/knex/knex/issues/3946) ##### Test / internal changes: - Change query lab link to https [#3933](https://togithub.com/knex/knex/issues/3933) ### [`v0.21.2`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0212---10-July-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.21.1...0.21.2) ##### New features: - Warn user if custom migration source is being reset [#3839](https://togithub.com/knex/knex/issues/3839) - Prefer `void` as return type on migration generator ts stub [#3865](https://togithub.com/knex/knex/issues/3865) - MSSQL: Added the removal of a columns default constraint, before dropping the column [#3855](https://togithub.com/knex/knex/issues/3855) ##### Typings: - Fix definition for raw querybuilders [#3846](https://togithub.com/knex/knex/issues/3846) ##### Test / internal changes: - Refactor migration logic to use async/await [#3838](https://togithub.com/knex/knex/issues/3838) ### [`v0.21.1`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02119---02-March-2021) [Compare Source](https://togithub.com/knex/knex/compare/0.21.0...0.21.1) - SQLite: Made the constraint detection case-insensitive [#4332](https://togithub.com/knex/knex/issues/4332) ### [`v0.21.0`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#0210---18-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.15...0.21.0) ##### Improvements - Reduce size of lodash in bundle [#3804](https://togithub.com/knex/knex/issues/3804) ##### Breaking changes - Dropped support for Node 8 - Breaking upstream change in `pg-query-stream`: `Changed stream.close to stream.destroy which is the official way to terminate a readable stream. This is a breaking change if you rely on the stream.close method on pg-query-stream...though should be just a find/replace type operation to upgrade as the semantics remain very similar (not exactly the same, since internals are rewritten, but more in line with how streams are "supposed" to behave).` ##### Test / internal changes: - Updated Tarn.js to a version 3.0.0 - Updated mkdirp to a version 1.0.4 - Updated examples to use ES2015 style [#3810](https://togithub.com/knex/knex/issues/3810) ### [`v0.20.15`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02015---16-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.14...0.20.15) ##### Bug fixes: - Support for `.finally(..)` on knex's Promise-alikes [#3800](https://togithub.com/knex/knex/issues/3800) ##### Typings: - Add types for `.distinctOn` [#3784](https://togithub.com/knex/knex/issues/3784) ### [`v0.20.14`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02014---13-April-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.13...0.20.14) ##### New features: - CLI: adds support for asynchronous knexfile loading [#3748](https://togithub.com/knex/knex/issues/3748) - Add clearGroup method [#3771](https://togithub.com/knex/knex/issues/3771) ##### Typings: - Support Raw types for insert, where, update [#3730](https://togithub.com/knex/knex/issues/3730) - Add typings for MigrationSource [#3756](https://togithub.com/knex/knex/issues/3756) - Update signature of orderBy to support QueryBuilder inside array [#3757](https://togithub.com/knex/knex/issues/3757) - Add toSQL and toString to SchemaBuilder [#3758](https://togithub.com/knex/knex/issues/3758) - `interface Knex` and `function Knex` should have the same types [#3787](https://togithub.com/knex/knex/issues/3787) - Fix minor issues around typings [#3765](https://togithub.com/knex/knex/issues/3765) ##### Test / internal changes: - Minor test internal enhancements [#3747](https://togithub.com/knex/knex/issues/3747) - Minor improvements on the usage of fs utilities [#3749](https://togithub.com/knex/knex/issues/3749) - Split tests in groups [#3785](https://togithub.com/knex/knex/issues/3785) ### [`v0.20.13`](https://togithub.com/knex/knex/blob/HEAD/CHANGELOG.md#02013---23-March-2020) [Compare Source](https://togithub.com/knex/knex/compare/0.20.12...0.20.13) ##### Bug fixes: - Correctly handle dateToString escaping without timezone passed [#3742](https://togithub.com/knex/knex/issues/3742) - Make protocol length check more defensive [#3744](https://togithub.com/knex/knex/issues/3744) ##### Typings: - Make the ChainableInterface conform to PromiseConfiguration
📅 Schedule: "before 2pm on Tuesday,before 2pm on Friday" in timezone Europe/Stockholm.
🚦 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 WhiteSource Renovate. View repository job log here.