7.0.0-alpha.29 (2023-09-13)

Bug Fixes

• improve association decorators (#16486) (b8edd52)
• postgres: cast VARCHAR[] columns (#16481) (df30331)
• prevent public class fields from shadowing association values (#16493) (b66db0b)

Features

• add built-in support for TypeScript enums & readonly arrays in DataTypes.ENUM (#16488) (d2a1c2f)
• migrate removeColumn to typescript (#16476) (bc35a52)
• option to allow specifying the default precision for auto-generated timestamp columns (#16330) (db7fe12)
• support iterables in association methods (#16491) (8acefff)

7.0.0-alpha.28 (2023-09-11)

Bug Fixes

• allow bind parameters in array literal (#16328) (4d624fd)
• build on windows machines (#16211) (808adeb)
• db2: use docker compose & set default schema as username (#16307) (c59011c)
• mssql: return aggregated error instead of last error (#16188) (dea29f7)
• outaded link on unsupported engines warning (#16435) (b376ac2)
• rename clsTransactionNestMode ➡️ defaultTransactionNestMode; ClsTransactionOptions ➡️ ManagedTransactionOptions (#16174) (8637a46)
• support array of tableHints and allow joins to use tableHints (#16242) (c081850)
• types: allow Op.contains on a jsonb column (#16167) (70c2bf5)

Features

• add constraint filters (#16199) (a734bab)
• migrate constraints to typescript (#15962) (0e17c07)
• migrate table queries to typescript (#16452) (c67db53)
• migrate tableExists to typescript (#16320) (5167e88)
• migrate version queries to typescript (#16153) (37dbf08)
• sqlite: split SQLite from MySQL (#16201) (789b690)
• types: migrate model-manager to TypeScript (#16070) (605150e)
• types: restrict attributes typing (#15607) (0012466)
• unify constraint queries (#16187) (62a59b0)
• update to TypeScript 5.2, drop support TS 4.8 (#16412) (875a84e)

BREAKING CHANGES

• Minimum TypeScript version is now 4.9

6.33.0 (2023-09-08)

Bug Fixes

• types: remove escape from query-interface types (#15944) (2eb7a5d)

Features

• types: add TypeScript 5.2 support (#16442) (367caf3)

7.0.0-alpha.27 (2023-06-21)

Bug Fixes

• fix Bulk Update failure when virtual attributes and getDataValue are involved (#15741) (f5a8815)
• merge getForeignKeysQuery with getForeignKeyQuery, unify unit tests and migrate to TS (#15454) (e940f42)
• postgres: prevent crash if postgres connection emits multiple errors (#15867) (42fbcc4)
• remove add/removeTicks (#15973) (ef00e92)
• types: fix generic type of Model#changed (#16047) (fad20ee)
• use singular association name to generate FK (#16142) (8f8f13e)

Features

• add nestMode option for managed transactions (#16143) (c4eef63)
• add included columns in index definition (#15405) (5c1c7ff)
• add support for model inheritance (#16095) (6c553a9)
• drop support for Node 14 and add for Node 20 (#16058) (39bf550)
• make set association method delete old associated entity for non-null FKs (#15840) (67d66f1)
• mariadb: drop 10.3 and add 11.0 support (#16133) (64e392d)
• migrate describeTable to typescript (#15945) (37bff7e)
• mssql: add json operations support (#15832) (b0ee419)
• mysql: support max_execution_time optimizer hint (#15341) (fc3d6aa)
• postgres: add stream to connectionConfig (#16056) (abeacd5)
• reject invalid options for createTableQuery (#15846) (2dcd69a)
• support TS 5.1, drop TS 4.7 (#16089) (0f2706d)
• update mariadb connector to v3 (#16139) (bc26271)

BREAKING CHANGES

• Sequelize now requires Node >=16.0.0
• mariadb: If using MariaDB, Sequelize requires MariaDB 10.4.30 or higher
• Minimum mariadb npm package version is now 3.1.2
• Minimum TypeScript version is now 4.8

6.32.1 (2023-06-17)

Bug Fixes

• bump dependencies (#16119) (a3213f0)

6.32.0 (2023-06-01)

Bug Fixes

• move types condition to the front (#16085) (99c3530)
• oracle: For Raw queries avoid converting the input parameters passed (#16067) (fd38e79)
• oracle: reordered check constraint for unsigned numeric type (#16074) (5c8250e)

Features

• oracle: add new error messages introduced in new driver version (#16075) (e07eefb)
• oracle: add width support for numerictype (#16073) (af4f0ae)

6.31.1 (2023-05-01)

Bug Fixes

• postgres: adds support for minifying through join aliases (#15897) (a9fd501)

7.0.0-alpha.26 (2023-04-11)

Bug Fixes

• deprecate setting quoteIdentifiers to false (#15879) (54e0db4)
• ibmi: correct check for connected connection (#15852) (64aa16e)
• mariadb: do not automatically parse JSON fields by checking meta (#15704) (0c0a4d4)
• mysql: don't print milliseconds if date precision is 0 (#15838) (551e7ef)
• remove undefined options in sequelize.define (#15817) (6b61ddf)
• restrict precision option in DATE and TIME to number (#15800) (7bd5907)
• sqlite: don't use mkdirp if the file already exists (#15909) (f5bbd6b)
• type createTableQuery and overhaul unit test suite (#15526) (b5db02d)
• type QueryGenerator.dropForeignKeyQuery and add tests (#15807) (0435174)
• type renameTableQuery, removeConstraintQuery, versionQuery (#15813) (8928c6d)

Features

• add queryInterface.withoutForeignKeyChecks, sequelize.destroyAll (#15842) (3cfe672)
• add sequelize.withConnection, rename sequelize.set to sequelize.setSessionVariables (#15851) (336d712)
• add Transaction#afterRollback, Transaction#afterTransaction (#15837) (4bca19a)
• add beforePoolAcquire and afterPoolAcquire hooks. (#15859) (6711351)
• move pg-hstore to prod dependencies (#15914) (aebb9ed)
• postgres: support connectionTimeoutMillis dialectOption (#15841) (8a98dde)
• support SRID in mysql/mariadb (#15835) (d326d84)

6.31.0 (2023-04-09)

Bug Fixes

• postgres: prevent crash if postgres connection emits multiple errors (#15868) (58576dd)
• update Slack invitation link (#15849) (9d864be)

Features

• add beforePoolAcquire and afterPoolAcquire hooks (#15874) (f2a4535)

6.30.0 (2023-03-24)

Bug Fixes

• pass CLS transaction to model hooks (#15818) (46d3553)

Features

• postgres, sqlite: add conflictWhere option to Model.bulkCreate (#15788) (295c297)
• postgres, sqlite: add conflictWhere option to upsert (#15786) (1e68681)
• postgres, sqlite: allow override of conflict keys for bulkCreate (#15787) (2e50bd9)