sequelize

6.27.0 (2022-12-12) Features

• add support for bigints (backport of #14485) (#15413) (1247c01)

6.26.0 (2022-11-29) Features

• postgres: add support for lock_timeout [#15345] (#15355) (94beace)

6.25.8 (2022-11-22) Bug Fixes

• oracle: remove hardcoded maxRows value (#15323) (7885000)

6.25.7 (2022-11-19) Bug Fixes

• fix parameters not being replaced when after $$ strings (#15307) (bc39fd6)

6.25.6 (2022-11-15) Bug Fixes

• postgres: invalidate connection after client-side timeout (#15283) (a205765), closes /github.com/brianc/node-postgres/blob/5538df6b446f4b4f921947b460fe38acb897e579/packages/pg/lib/client.js#L529

6.25.5 (2022-11-07) Bug Fixes

• remove options.model overwrite on bulkUpdate (#15252) (67e69cd), closes #15231

6.25.4 (2022-11-05) Bug Fixes

• types: add instance.dataValues property to model.d.ts (#15240) (00c6da3)

6.25.3 (2022-10-19) Bug Fixes

• don't treat \ as escape in standard strings, support E-strings, support vars after ->> operator, treat lowercase e as valid e-string prefix (#15139) (7990095), closes #14700

6.25.2 (2022-10-15) Bug Fixes

• types: fix TS 4.9 excessive depth error on InferAttributes (v6) (#15135) (851daaf)

6.25.1 (2022-10-13) Bug Fixes

• types: expose legacy "types" folder in export alias ( #15123) (9dd93b8)

6.25.0 (2022-10-11) Features

• oracle: add support for dialectOptions.connectString (#15042) (06ad05d)

6.24.0 (2022-10-04) Features

• snowflake: Add support for QueryGenerator#tableExistsQuery (#15087) (a44772e)

6.23.2 (2022-09-27) Bug Fixes

• postgres: add custom order direction to subQuery ordering with minified alias (#15056) (7203b66)

6.23.1 (2022-09-22) Bug Fixes

• oracle: add support for Oracle DB 18c CI (#15016) (5f621d7), closes #1 #7 #9 #13 #14 #16

6.23.0 (2022-09-17) Features

• types: add typescript 4.8 compatibility (#14990) (3468378)

6.22.1 (2022-09-16) Bug Fixes

• types: missing type for oracle dialect in v6 (#14992) (1da6657), closes #14991

6.22.0 (2022-09-15) Features

• oracle: add oracle dialect support (#14638) (c230d80), closes #1 #7 #9 #13 #14 #16

6.21.6 (2022-09-09) Bug Fixes

• types: backport #14704 for v6 (#14964) (33d94b2)

6.21.5 (2022-09-08) Bug Fixes

• mariadb: do not automatically parse JSON fields (#14800) (d047f32)

6.21.4 (2022-08-18) Bug Fixes

• minified aliases are now properly referenced in subqueries (v6) (#14852) (5a257bc), closes #14804

6.21.3 (2022-07-11) Bug Fixes

• postgres: attach postgres error-handler earlier in lifecycle (v6) (#14731) (90bb694)

6.21.2 (2022-06-28) Bug Fixes

• properly escape multiple $ in fn args (#14678) (7bb60e3)

6.21.1 (2022-06-25) Bug Fixes

• postgres: use schema set in sequelize config by default (#14665) (2f3b924)

6.21.0 (2022-06-16) Features

• exports types to support typescript >= 4.5 nodenext module (#14620) (cbdf73e)

6.20.1 (2022-05-27) Bug Fixes

• kill connection on commit/rollback error (#14535) (e1a9c28)

6.20.0 (2022-05-23) Features

• support cyclic foreign keys (#14499) (b37df96)

6.19.2 (2022-05-18) Bug Fixes

• accept replacements in ARRAY[] & followed by ; (#14518) (e37c572)

6.19.1 (2022-05-17) Bug Fixes

• do not replace :replacements inside of strings (#14472) (ccaa399)

⚠️ BREAKING CHANGE: This change is a security fix that patches a serious SQL injection vulnerability, however it is possible that your application made use of it and broke as a result of this change. Please see this issue for more information.

6.19.0 (2022-04-12) Bug Fixes

• types: make WhereOptions more accurate (#14368) (0d0aade)

Features

• types: make Model.init aware of pre-configured foreign keys (#14370) (5954d2c)

6.18.0 (2022-04-03) Features

• add whereScopeStrategy to merge where scopes with Op.and (#14152) (8349c02)

6.17.0 (2022-02-25) Bug Fixes

• fix typo in query-generator.js error message (#14151) (2d339d0)
• postgres: correctly re-acquire connection for pg-native (#14090) (82506a6)
• types: drop excess argument for upsert (#14156) (da8678d)
• types: export GroupedCountResultItem interface (#14154) (a81b7ab)
• types: update 'replication' option property (#14126) (7ac1221)
• types: update return type of Model.update (#14155) (b80aeed)

Features

• types: infer nullable creation attributes as optional (#14147) (f5c06bd)
• types: make Model.getAttributes stricter (#14017) (e974e20)

6.16.3 (2022-02-24) Bug Fixes

• types: support union in CreationAttributes (#14146) (d23bd7a)

6.16.2 (2022-02-18) Bug Fixes

• types: missing snowflake and db2 dialects (#14137) (0326c2c)

7.0.0-alpha.9 (2022-02-15) Features

• forbid using attr names that are ambiguous with $nested.syntax$ (#13992) (b3c2270)

7.0.0-alpha.8 (2022-02-11) Features

• forbid using attr names that are ambiguous with $nested.syntax$ (#13992) (bd96cb8)

7.0.0-alpha.7 (2022-02-10) Features

• gen /lib & /types from /src & drop /dist (main) (#14068) (491ff15)
• types: make Model.getAttributes stricter (#14017) (145ce65)

6.16.1 (2022-02-09) Bug Fixes

• correct path to package.json in Sequelize.version (#14073) (b95c213)

6.16.0 (2022-02-08) Features

• gen /lib & /types from /src & drop /dist (v6) (#14063) (6b8fbb4)

7.0.0-alpha.6 (2022-02-07) Bug Fixes

• don't call overloaded versions of find functions internally (#13951) (e5d02ef)
• fix typings for queries with {plain: true} option (#13899) (d139b2e)
• model.d: fix type for count and findAndCountAll (#13786) (cf27c66)
• types: accept $nested.syntax$ in WhereAttributeHash (#13983) (f72bb1e)
• types: add hooks to InstanceDestroyOptions type (#13491) (6d4b553)
• types: add missing fields to FindOr{Create,Build}Options (#13389) (81b0b9d)
• types: correct typing definitions for Sequelize.where (#14018) (308ace0)
• types: deduplicate error typings (#14002) (3f75880)
• types: fix QueryInterface#bulkInsert attribute arg type (#13945) (36ad644)
• types: improve branded types (#13990) (940060a)

Features

• add options.rawErrors to Sequelize#query method (#13881) (4c8fa9a)
• mariadb: add mariadb support in Sequelize.set function (#13926) (6056bb3), closes #13920
• postgres: drop indices concurrently in Postgres (#13903) (ad08cd7)
• types: add InferAttributes utility type (#13909) (7eff04a)
• types: add typings for DataTypes.TSVECTOR (#13940) (35859a4)
• types: drop TypeScript < 4.1 (#13954) (d384a87)

6.15.1 (2022-02-06) Bug Fixes

• types: accept $nested.syntax$ in WhereAttributeHash (#13983) (4a513cf)
• types: correct typing definitions for Sequelize.where (#14018) (99c612b)
• types: improve branded types (#13990) (a578ea0)

6.15.0 (2022-01-29) Bug Fixes

• types: deduplicate error typings (#14002) (fc28629)

Features

• add options.rawErrors to Sequelize#query method (#13881) (7c58851)

6.14.1 (2022-01-25) Bug Fixes

• rollback PR #13951 in v6 (#14004) (1882f3c)

6.14.0 (2022-01-22) Bug Fixes

• don't call overloaded versions of find functions internally (#13951) (fc53cdb)
• don't call overloaded versions of find functions internally (#13951) (b253d8e)
• model.d: fix type for count and findAndCountAll (#13786) (b06c1fc)
• types: add hooks to InstanceDestroyOptions type (#13491) (dbd9ea8)
• types: add missing fields to FindOr{Create,Build}Options (#13389) (ef63f8f)
• types: fix QueryInterface#bulkInsert attribute arg type (#13945) (9e108e3)

Features

• types: add InferAttributes utility type (#13909) (fd42687)
• types: add typings for DataTypes.TSVECTOR (#13940) (b8f0463)
• types: drop TypeScript < 4.1 (#13954) (dd49044)

6.13.0 (2022-01-10) Bug Fixes

• fix typings for queries with {plain: true} option (#13899) (308d017)

Features

• mariadb: add mariadb support in Sequelize.set function (#13926) (02bda05), closes #13920
• postgres: drop indices concurrently in Postgres (#13903) (37f20a6)

7.0.0-alpha.5 (2022-01-04) Bug Fixes

• dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (1e2b771)
• model: fix count with grouping typing (#13884) (c206337), closes #13871
• types: improve ModelCtor / ModelStatic typing (#13890) (d355822)
• types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (e23e422)

Reverts

• Revert "ci: temporarily disable tests" (0ed16e9)

7.0.0-alpha2.2 (2022-01-04) Bug Fixes

• dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (1e2b771)
• model: fix count with grouping typing (#13884) (c206337), closes #13871
• types: improve ModelCtor / ModelStatic typing (#13890) (d355822)
• types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (e23e422)

Reverts

• Revert "ci: temporarily disable tests" (0ed16e9)
• Revert "ci: disable all test steps temporarily" (a699e6f)

6.12.5 (2022-01-04) Bug Fixes

• dialect: sequelize pool doesn't take effect in dialect "mssql" (#13880) (fc155b6)
• model: fix count with grouping typing (#13884) (49beb29), closes #13871
• types: improve ModelCtor / ModelStatic typing (#13890) (34aa808)
• types: omit FK and scope keys in HasManyCreateAssociationMixin (#13892) (b315ce8)

7.0.0-alpha2.1 (2022-01-04) Bug Fixes

• data-types: moment object throwing error (#13818) (cdd1760)
• mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (2a2cc05)
• semantic-release should not push beta or alpha to default channel (#13863) (250a315)

Continuous Integration

• releases: prepare v7 alpha releases (6e597c6)
• releases: prepare v7 alpha releases (98ad525)

BREAKING CHANGES

• releases: This commit prepares the new v7 alpha development branch.
• releases: This commit prepares the new v7 alpha development branch.

7.0.0-alpha.4 (2022-01-01) Bug Fixes

• mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (2a2cc05)
• semantic-release should not push beta or alpha to default channel (#13863) (250a315)

6.12.4 (2021-12-28) Bug Fixes

• mssql/async-queue: fix unable to start mysql due to circular ref (#13823) (49e8614)

7.0.0-alpha.3 (2021-12-27) Bug Fixes

• data-types: moment object throwing error (#13818) (cdd1760)

Continuous Integration

• releases: prepare v7 alpha releases (6e597c6)

BREAKING CHANGES

• releases: This commit prepares the new v7 alpha development branch.

6.12.3 (2021-12-27) Bug Fixes

• data-types: moment object throwing error (#13818) (78c7414)

7.0.0-alpha.2 (2021-12-23) Reverts

• Revert "ci(release): temporary disable major-release-fail" (cd5a605)

7.0.0-alpha.1 (2021-12-23) Continuous Integration

• releases: prepare v7 alpha releases (98ad525)

BREAKING CHANGES

• releases: This commit prepares the new v7 alpha development branch.

6.12.2 (2021-12-22) Bug Fixes

• abstract: patch jsonb operator for pg if value is json (#13780) (a2375c5)
• operators: fix ts support for operators.ts (#13805) (b532ab1)
• postgres: allows usage of schema for ARRAY(ENUM) type name (#13807) (da5b0ce)
• query-interface: bring back quoteIdentifier(s) to queryInterface (#13810) (001dc60)

5.22.5 (2021-12-21) Bug Fixes

• dependencies: update validator dependency to latest version (#13802) (9f47e94)

6.12.1 (2021-12-21) Bug Fixes

• allow deep imports (#13795) (1ecdaf9)
• fix invalid ts import style of lib/operators (#13797) (8acc14f)

6.12.0 (2021-12-17) Bug Fixes

• data-types: unnecessary warning when getting data with DATE dataTypes (#13712) (121884b)
• docs: add aws-lamda route (#13693) (3059bce)
• example: fix coordinates format as per GeoJson (#13718) (f9dec20)
• increment: fix key value broken query (#12985) (fc0b19e)
• model.d: fix findAndCountAll.count type (#13736) (b7b472e)
• snowflake: fix to prevent disconnect attempt on already disconnected connection (#13775) (2a9a551)
• types: add Col to where Ops (#13717) (2d7b865)
• types: add instance member declaration (#13684) (ae3cde5)
• types: add missing schema field to sequelize options (c7a0839), closes #12606
• types: allow override json function with custom return type (#13694) (2c3b384)
• upsert: fall back to DO NOTHING if no update key values provided (#13594) (4071378)
• upsert: fall back to DO NOTHING if no update key values provided (#13711) (f9dfaa7), closes #13594
• wrong interface used within mixin (#13685) (bd3ddf5)

Features

• dialects: add experimental support for db2 (#13374) (4443d2a)
• dialect: snowflake dialect support (#13406) (ad68a5e)
• model: complete getAttributes feature (b6510df)
• typescript: create alpha release with ts (911125e)
• types: transition lib/errors (#13710) (8cdce6a)
• upsert: add conflictFields option (#13723) (496bede)

6.12.0-beta.3 (2021-12-12) Features

• model: complete getAttributes feature (b6510df)
• upsert: add conflictFields option (#13723) (496bede)

6.12.0-beta.2 (2021-12-10) Features

• dialects: add experimental support for db2 (#13374) (4443d2a)
• types: transition lib/errors (#13710) (8cdce6a)

6.12.0-beta.1 (2021-12-04) Bug Fixes

• data-types: unnecessary warning when getting data with DATE dataTypes (#13712) (121884b)
• docs: add aws-lamda route (#13693) (3059bce)
• example: fix coordinates format as per GeoJson (#13718) (f9dec20)
• increment: fix key value broken query (#12985) (fc0b19e)
• types: add Col to where Ops (#13717) (2d7b865)
• types: add instance member declaration (#13684) (ae3cde5)
• types: add missing schema field to sequelize options (c7a0839), closes #12606
• types: allow override json function with custom return type (#13694) (2c3b384)
• upsert: fall back to DO NOTHING if no update key values provided (#13594) (4071378)
• upsert: fall back to DO NOTHING if no update key values provided (#13711) (f9dfaa7), closes #13594
• wrong interface used within mixin (#13685) (bd3ddf5)

Features

• dialect: snowflake dialect support (#13406) (ad68a5e)
• typescript: create alpha release with ts (911125e)

6.12.0-alpha.1 (2021-11-19) Features

• typescript: create alpha release with ts (8b2854a)

6.11.0 (2021-11-18) Features

• option for attributes having dotNotation (#13670) (41876f1)

6.10.0 (2021-11-18) Bug Fixes

• typing on creation within an association (#13678) (0312f8e)
• logger: change logging depth from 3 to 1 (#12879) (ddddc24)
• mariadb: fix MariaDB 10.5 JSON (#13633) (cdd61dd)
• model: clone options object instead of modifying (#13589) (3be43de)
• mssql: fix sub query issue occurring with renamed primary key fields (#12801) (73d99ab)
• mssql: sqlserver 2008 fix for using offsets and include criteria (47c4494)
• query: make stacktraces include original calling code (#13347) (f581543)
• types: Add missing type definitions in models (#13553) (73ecf6c)
• types: add specifc tojson type in model.d.ts (#13661) (5924be5)
• types: DataType.TEXT overloading definition (#13654) (1690801)
• types: include 'paranoid' in IncludeThroughOptions definition (#13625) (b1fb1f3)
• types: ne op documentation (#13666) (98485df)
• types: rename types and update CONTRIBUTING docs (#13348) (1f23924)
• expect result is null but got zero (#13637) (da3ac09)

Features

• definitions: Adds AbstractQuery and before/afterQuery hook definitions (#13635) (37a5858)
• postgresql: easier SSL config and options param support (#13673) (9591573)

6.9.0 (2021-11-01) Bug Fixes

• docs: using incorrect esdocs syntax (#13615) (c3c690b)
• sqlite: quote table names in sqlite getForeignKeysQuery (#13587) (eeb6a8f)
• upsert: do not overwrite an explcit created_at during upsert (#13593) (594cee8)

Features

• mysql: add support for MySQL v8 (#13618) (35978f0)

6.8.0 (2021-10-24) Bug Fixes

• types: allow any values in isIn validator (#12962) (d511d91)
• allows insert primary key with zero (#13458) (e4aff2f)
• model: Convert number values only if they aren't null to avoid NaN (199b632)
• model.d: accept [Op.is] in where (broken in TypeScript 4.4) (#13499) (d685a9a)
• postgres: fix findCreateFind to work with postgres transactions (#13482) (84421d7)
• select: do not force set subQuery to false (#13490) (0943339)
• sqlite: fix wrongly overwriting storage if empty string (#13376) (c3e608b), closes #13375
• types: add missing upsert hooks (#13394) (5e9c209)
• types: extend BulkCreateOptions by SearchPathable (#13469) (47c2d05), closes #13454
• types: typo in model.d.ts (#13574) (31d0fbc)

Features

• postgres: support query_timeout dialect option (#13258) (3ca085d)
• typings: add UnknownConstraintError (#13461) (69d899e)

6.7.0 (2021-10-09) Bug Fixes

• deps: upgrade to secure versions of dev deps (#13549) (cf53734)
• docs: fix typo in documentation for polymorphic associations (#13405) (bbf3d76)
• types: allow rangable to take a string tuple (#13486) (ca2a11a)

Features

• test: add test for nested column in where query (#13478) (26b62c7), closes #13288
• types: make config type deeply writeable for before connect hook (#13424) (f078f77)

6.6.5 (2021-07-06) Bug Fixes

• dependency: upgrade validator (#13350) (56bb1d6)

6.6.4 (2021-06-26) Bug Fixes

• typings: make Transactionable compatible with TransactionOptions (#13334) (cd2de40)
• utils: clone attributes before mutating them (#13226) (1a16b91)
• data-types: use proper field name for ARRAY(ENUM) (#13210) (1cfbd33)
• typings: fix ignoreDuplicates option (#13220) (b33d78e)
• typings: allow schema for queryInterface methods (#13223) (6b0b532)
• typings: restrict update typings (#13216) (63ceb73)
• typings: returning can specify column names (#13215) (143cc84)
• typings: model init returns model class, not instance (#13214) (8f2a0d5)
• plurals: bump inflection dependency (#13260) (deeb5c6)
• bulk-create: ON CONFLICT with unique index (#13345) (6dcb565)

6.6.2 (2021-03-23) Bug Fixes

• types: fix Model.prototype.previous() (#13042) (5b16b32)

6.6.1 (2021-03-22) Bug Fixes

• query-generator: use AND in sql for not/between (#13043) (a663c54)
• sqlite: retrieve primary key on upsert (#12991) (023e1d9)
• types: allow (keyof TAttributes)[] in UpdateOptions.returning (#13130) (97ba242)
• types: models with attributes couldn't be used in some cases (#13010) (de5f21d)
• types: remove string from Order type (#13057) (ac39f8a)

6.6.0 (2021-03-21) Bug Fixes

• types: allow sequelize.col in attributes (#13105) (3fd64cb)
• types: allow bigints in WhereValue (#13028) (8892507)
• types: decapitalize queryGenerator property (#13126) (9cb4d7f)
• types: fix Model#previous type (#13106) (466e361)
• types: fix ValidationErrorItem types (#13108) (e35a9bf)

Features

• add-constraint: add deferrable option (#13096) (f98bd7e)

5.22.4 (2021-03-14) Bug Fixes

• types: allow transaction to be null (#13093) (#13101) (db6d5ec)

6.5.1 (2021-03-14) Bug Fixes

• mysql: release connection on deadlocks (#13102) (6388507)
  • Note: this complements the work done in 6.5.0, fixing another situation not covered by it with MySQL.
• types: allow transaction to be null (#13093) (ced4dc7)

6.5.0 (2021-01-27)

Second release in 2021! 🎉

Bug Fixes

• mysql, mariadb: release connection on deadlocks (#12841) (c77b1f3)
• types: allow changing values on before hooks (#12970) (e5b8929)
• types: typo in sequelize.js and sequelize.d.ts (#12975) (2fe980e)

Features

• postgres: add TSVECTOR datatype and @@ operator (#12955) (e45df29)

6.4.0 (2021-01-18)

First release in 2021! 🎉

Bug Fixes

• types: better support for readonly arrays (287607a)
• types: remove part forgotten in #12175 (2249ded)

Features

• query-interface: support composite foreign keys (#12456) (9ecebef)

6.3.5 (2020-09-01) Bug Fixes

• truncate: fix missing await in truncate all models with cascade (#12664) (933b3f6)

6.3.4 (2020-08-01) Bug Fixes

• model: handle true timestamp fields correctly (#12580) (#12581) (490db41)

6.3.3 (2020-07-11) Bug Fixes

• mark database drivers as optional peer dependencies (#12484) (ec2af0d)

6.3.2 (2020-07-11) Bug Fixes

• upsert: set isNewRecord to false when upserting (#12447) (#12485) (96f4166)

6.3.1 (2020-07-10) Bug Fixes

• use lodash baseIsNative directly instead of .isNative (#12358) (#12475) (#12480) (631f555)

6.3.0 (2020-07-04) Bug Fixes

• mssql: upsert query with falsey values (#12453) (#12459) (4d82907)

Features

• types: Add ModelDefined type as syntactic sugar (#12445) (5cabcbc)

6.2.4 (2020-07-01) Bug Fixes

• types: update SaveOptions type to include Hookable (#12441) (#12444) (9a45509)

5.22.3 (2020-06-30) Bug Fixes

• sqlite: describeTable now returns unique and references (#12440) (3d2df28)

6.2.3 (2020-06-28) Bug Fixes

• sqlite: describeTable now returns unique constraint and references (#12420) (2de3377)

6.2.2 (2020-06-27) Bug Fixes

• types: fixed types for model.init and sequelize.define; update docs (#12435) (9c446f9)

6.2.1 (2020-06-27) Bug Fixes

• mssql: insert/upsert operations do not return all fields (#12433) (aeb318a)

5.22.2 (2020-06-27) Bug Fixes

• mssql: insert/upsert operations do not return all fields (#12434) (56d07c6)

6.2.0 (2020-06-26) Bug Fixes

• types: references support for string (#12407) (962ed3c)

Features

• types: added optional stricter typing for Model attributes (#12405) (871157b)

5.22.1 (2020-06-26) Bug Fixes

• mssql: bulkUpdate returning values (#12410) (ad1c153)
• tests: correct spelling mistakes (#12422) (26fcbce)

6.1.1 (2020-06-26) Bug Fixes

• mssql: returning data for bulkUpdate (#12413) (e36212c)

Sequelize v6 is the next major release after v5. Below is a list of breaking changes to help you upgrade.

Breaking Changes Support for Node 10 and up

Sequelize v6 will only support Node 10 and up #10821.

CLS

You should now use cls-hooked package for CLS support.

  const cls = require('cls-hooked');
  const namespace = cls.createNamespace('....');
  const Sequelize = require('sequelize');

  Sequelize.useCLS(namespace);

Database Engine Support

We have updated our minimum supported database engine versions. Using older database engine will show SEQUELIZE0006 deprecation warning. Please check ENGINE.md for version table.

Sequelize

• Bluebird has been removed. Internally all methods are now using async/await. Public API now returns native promises. Thanks to Andy Edwards for this refactor work.
• Sequelize.Promise is no longer available.
• sequelize.import method has been removed.

Model options.returning

Option returning: true will no longer return attributes that are not defined in the model. Old behavior can be achieved by using returning: ['*'] instead.

Model.changed()

This method now tests for equality with _.isEqual and is now deep aware for JSON objects. Modifying a nested value for a JSON object won't mark it as changed (since it is still the same object).

  const instance = await MyModel.findOne();

  instance.myJsonField.someProperty = 12345; // Changed from something else to 12345
  console.log(instance.changed()); // false

  await instance.save(); // this will not save anything

  instance.changed('myJsonField', true);
  console.log(instance.changed()); // ['myJsonField']

  await instance.save(); // will save

Model.bulkCreate()

This method now throws Sequelize.AggregateError instead of Bluebird.AggregateError. All errors are now exposed as errors key.

Model.upsert()

Native upsert is now supported for all dialects.

const [instance, created] = await MyModel.upsert({});

Signature for this method has been changed to Promise<Model,boolean | null>. First index contains upserted instance, second index contains a boolean (or null) indicating if record was created or updated. For SQLite/Postgres, created value will always be null.

• MySQL - Implemented with ON DUPLICATE KEY UPDATE
• PostgreSQL - Implemented with ON CONFLICT DO UPDATE
• SQLite - Implemented with ON CONFLICT DO UPDATE
• MSSQL - Implemented with MERGE statement

Note for Postgres users: If upsert payload contains PK field, then PK will be used as the conflict target. Otherwise first unique constraint will be selected as the conflict key.

QueryInterface addConstraint

This method now only takes 2 parameters, tableName and options. Previously the second parameter could be a list of column names to apply the constraint to, this list must now be passed as options.fields property.

Changelog 6.0.0-beta.7

• docs(associations): belongs to many create with through table
• docs(query-interface): fix broken links #12272
• docs(sequelize): omitNull only works for CREATE/UPDATE queries
• docs: asyncify #12297
• docs: responsive #12308
• docs: update feature request template
• feat(postgres): native upsert #12301
• feat(sequelize): allow passing dialectOptions.options from url #12404
• fix(include): check if attributes specified for included through model #12316
• fix(model.destroy): return 0 with truncate #12281
• fix(mssql): empty order array generates invalid FETCH statement #12261
• fix(postgres): parse enums correctly when describing a table #12409
• fix(query): ensure correct return signature for QueryTypes.RAW #12305
• fix(query): preserve cls context for logger #12328
• fix(query-generator): do not generate GROUP BY clause if options.group is empty #12343
• fix(reload): include default scope #12399
• fix(types): add Association into OrderItem type #12332
• fix(types): add clientMinMessages to Options interface #12375
• fix(types): transactionType in Options #12377
• fix(types): add support for optional values in "where" clauses #12337
• fix(types): add missing fields to 'FindOrCreateType' #12338
• fix: add missing sql and parameters properties to some query errors #12299
• fix: remove custom inspect #12262
• refactor: cleanup query generators #12304

6.0.0-beta.6

• docs(add-constraint): options.fields support
• docs(association): document uniqueKey for belongs to many #12166
• docs(association): options.through.where support
• docs(association): use and instead of 'a nd' #12191
• docs(association): use correct scope name #12204
• docs(manuals): avoid duplicate header ids #12201
• docs(model): correct syntax error in example code #12137
• docs(query-interface): removeIndex indexNameOrAttributes #11947
• docs(resources): add sequelize-guard library #12235
• docs(typescript): fix confusing comments #12226
• docs(v6-guide): bluebird removal API changes
• docs: database version support info #12168
• docs: remove remaining bluebird references #12167
• feat(belongs-to-many): allow creation of paranoid join tables #12088
• feat(belongs-to-many): get/has/count for paranoid join table #12256
• feat(pool): expose maxUses pool config option #12101
• feat(postgres): minify include aliases over limit #11940
• feat(sequelize): handle query string host value #12041
• fix(associations): ensure correct schema on all generated attributes #12258
• fix(docs/instances): use correct variable for increment #12087
• fix(include): separate queries are not sub-queries #12144
• fix(model): fix unchained promise in association logic in bulkCreate #12163
• fix(model): updateOnDuplicate handles composite keys #11984
• fix(model.count): distinct without any column generates invalid SQL #11946
• fix(model.reload): ignore options.where and always use this.where() #12211
• fix(mssql) insert record failure because of BOOLEAN column type #12090
• fix(mssql): cast sql_variant in query generator #11994
• fix(mssql): dont use OUTPUT INSERTED for update without returning #12260
• fix(mssql): duplicate order in FETCH/NEXT queries #12257
• fix(mssql): set correct scale for float #11962
• fix(mssql): tedious v9 requires connect call #12182
• fix(mssql): use uppercase for engine table and columns #12212
• fix(pool): show deprecation when engine is not supported #12218
• fix(postgres): addColumn support ARRAY(ENUM) #12259
• fix(query): do not bind $ used within a whole-word #12250
• fix(query-generator): handle literal for substring based operators #12210
• fix(query-interface): allow passing null for query interface insert #11931
• fix(query-interface): allow sequelize.fn and sequelize.literal in fields of IndexesOptions #12224
• fix(scope): don't modify original scope definition #12207
• fix(sqlite): multiple primary keys results in syntax error #12237
• fix(sync): pass options to all query methods #12208
• fix(typings): add type_helpers to file list #12000
• fix(typings): correct Model.init return type #12148
• fix(typings): fn is assignable to where #12040
• fix(typings): getForeignKeysForTables argument definition #12084
• fix(typings): make between operator accept date ranges #12162
• refactor(ci): improve database wait script #12132
• refactor(tsd-test-setup): add & setup dtslint #11879
• refactor: move all dialect conditional logic into subclass #12217
• refactor: remove sequelize.import helper #12175
• refactor: use native versions #12159
• refactor: use object spread instead of Object.assign #12213

6.0.0-beta.5

• fix(find-all): throw on empty attributes #11867
• fix(types): queryInterface.addIndex #11844
• fix(types): plain option in sequelize.query #11596
• fix(types): correct overloaded method order #11727
• fix(types): comparator arg of Sequelize.where #11843
• fix(types): fix BelongsToManyGetAssociationsMixinOptions #11818
• fix(types): adds hooks to CreateOptions #11736
• fix(increment): broken queries #11852
• fix(associations): gets on many-to-many with non-primary target key #11778
• fix: properly select SRID if present #11763
• feat(sqlite): automatic path provision for options.storage #11853
• feat(postgres): idle_in_transaction_session_timeout connection option #11775
• feat(index): improve to support multiple fields with operator #11934
• docs(transactions): fix addIndex example and grammar #11759
• docs(raw-queries): remove outdated info #11833
• docs(optimistic-locking): fix missing manual #11850
• docs(model): findOne return value for empty result #11762
• docs(model-querying-basics.md): add some commas #11891
• docs(manuals): fix missing models-definition page #11838
• docs(manuals): extensive rewrite #11825
• docs(dialect-specific): add MSSQL domain auth example #11799
• docs(associations): fix typos in assocs manual #11888
• docs(associations): fix typo #11869

6.0.0-beta.4

• feat(sync): allow to bypass drop statements when sync with alter enabled #11708
• fix(model): injectDependentVirtualAttrs on included models #11713
• fix(model): generate ON CONFLICT ... DO UPDATE correctly #11666
• fix(mssql): optimize formatError RegEx #11725
• fix(types): add getForeignKeyReferencesForTable type #11738
• fix(types): add 'restore' hooks to types #11730
• fix(types): added 'fieldMaps' to QueryOptions typings #11702
• fix(types): add isSoftDeleted to Model #11628
• fix(types): fix upsert typing #11674
• fix(types): specified 'this' for getters and setters in fields #11648
• fix(types): add paranoid to UpdateOptions interface #11647
• fix(types): include 'as' in IncludeThroughOptions definition #11624
• fix(types): add Includeable to IncludeOptions.include type #11622
• fix(types): transaction lock #11620
• fix(sequelize.fn): escape dollarsign (#11533) #11606
• fix(types): add nested to Includeable #11354
• fix(types): add date to where #11612
• fix(types): add getDatabaseName (#11431) #11614
• fix(types): beforeDestroy #11618
• fix(types): query-interface table schema #11582
• docs: README.md #11698
• docs(sequelize): detail options.retry usage #11643
• docs: clarify logging option in Sequelize constructor #11653
• docs(migrations): fix syntax error in example #11626
• docs: describe logging option #11654
• docs(transaction): fix typo #11659
• docs(hooks): add info about belongs-to-many #11601
• docs(associations): fix typo #11592

6.0.0-beta.3

• feat: support cls-hooked / tests #11584

6.0.0-beta.2

• feat(postgres): change returning option to only return model attributes #11526
• fix(associations): allow binary key for belongs-to-many #11578
• fix(postgres): always replace returning statement for upsertQuery
• fix(model): make .changed() deep aware #10851
• change: use node 10 #11580

5.22.0 (2020-06-24) Bug Fixes

• postgres: parse enums correctly when describing a table (#12409) (#12411) (834b9f0)

Features

• sequelize: allow passing dialectOptions.options from url (#12412) (2391d08)

5.21.13 (2020-06-14) Bug Fixes

• types: specified 'this' for getters and setters in fields (#12370) (7fba668)

5.21.12 (2020-06-05) Bug Fixes

• mssql: set correct scale for float (#12340) (41237ae)

5.21.11 (2020-05-26) Bug Fixes

• include: check if attributes specified for included through model (#12020) (5c733ef)

5.21.10 (2020-05-19) Bug Fixes

• mssql: tedious connect deprecation (#12275) (7fdc2dc)

6.0.0-beta.6

• docs(add-constraint): options.fields support
• docs(association): document uniqueKey for belongs to many #12166
• docs(association): options.through.where support
• docs(association): use and instead of 'a nd' #12191
• docs(association): use correct scope name #12204
• docs(manuals): avoid duplicate header ids #12201
• docs(model): correct syntax error in example code #12137
• docs(query-interface): removeIndex indexNameOrAttributes #11947
• docs(resources): add sequelize-guard library #12235
• docs(typescript): fix confusing comments #12226
• docs(v6-guide): bluebird removal API changes
• docs: database version support info #12168
• docs: remove remaining bluebird references #12167
• feat(belongs-to-many): allow creation of paranoid join tables #12088
• feat(belongs-to-many): get/has/count for paranoid join table #12256
• feat(pool): expose maxUses pool config option #12101
• feat(postgres): minify include aliases over limit #11940
• feat(sequelize): handle query string host value #12041
• fix(associations): ensure correct schema on all generated attributes #12258
• fix(docs/instances): use correct variable for increment #12087
• fix(include): separate queries are not sub-queries #12144
• fix(model): fix unchained promise in association logic in bulkCreate #12163
• fix(model): updateOnDuplicate handles composite keys #11984
• fix(model.count): distinct without any column generates invalid SQL #11946
• fix(model.reload): ignore options.where and always use this.where() #12211
• fix(mssql) insert record failure because of BOOLEAN column type #12090
• fix(mssql): cast sql_variant in query generator #11994
• fix(mssql): dont use OUTPUT INSERTED for update without returning #12260
• fix(mssql): duplicate order in FETCH/NEXT queries #12257
• fix(mssql): set correct scale for float #11962
• fix(mssql): tedious v9 requires connect call #12182
• fix(mssql): use uppercase for engine table and columns #12212
• fix(pool): show deprecation when engine is not supported #12218
• fix(postgres): addColumn support ARRAY(ENUM) #12259
• fix(query): do not bind $ used within a whole-word #12250
• fix(query-generator): handle literal for substring based operators #12210
• fix(query-interface): allow passing null for query interface insert #11931
• fix(query-interface): allow sequelize.fn and sequelize.literal in fields of IndexesOptions #12224
• fix(scope): don't modify original scope definition #12207
• fix(sqlite): multiple primary keys results in syntax error #12237
• fix(sync): pass options to all query methods #12208
• fix(typings): add type_helpers to file list #12000
• fix(typings): correct Model.init return type #12148
• fix(typings): fn is assignable to where #12040
• fix(typings): getForeignKeysForTables argument definition #12084
• fix(typings): make between operator accept date ranges #12162
• refactor(ci): improve database wait script #12132
• refactor(tsd-test-setup): add & setup dtslint #11879
• refactor: move all dialect conditional logic into subclass #12217
• refactor: remove sequelize.import helper #12175
• refactor: use native versions #12159
• refactor: use object spread instead of Object.assign #12213

5.21.9 (2020-05-14) Bug Fixes

• mssql: use uppercase for engine table and columns (#12253) (8a3827d)