knex/knex
### [`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/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148)
[Compare Source](https://togithub.com/knex/knex/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148)
Configuration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
^0.95.14
->^1.0.0
Release Notes
knex/knex
### [`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/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148) [Compare Source](https://togithub.com/knex/knex/compare/0.95.14...380cebefcbf04219f51dfeb0e06efc735796c148)Configuration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by WhiteSource Renovate. View repository job log here.