6.37.6 (2025-03-04)

Bug Fixes

• add call for new maintainers to README (#17701) (ef3bffb)

7.0.0-alpha.45 (2025-02-17)

Bug Fixes

• add call for new maintainers to README (#17700) (ee3c7d3)
• core: Adjust model validator types yet again (#17689) (942b086)
• core: Further improve type declaration for model validation functions (#17686) (351b809)
• core: stop index hints from incorrectly being passed down to associations (#17559) (38162da)
• update type definition for orderItem to use variadic type (#17714) (1b61756)

Features

• findByPk composite key support (#17393) (afc9c0b)

7.0.0-alpha.44 (2025-01-27)

Bug Fixes

• core: adjust Model.sum|min|max return type to include null (#17527) (5135e83)
• core: Improve type declaration for model validation functions (#17586) (78fd0ea)
• remove deprecated tasksRunnerOptions (#17652) (b0c7778)
• snowflake: automatically fetch last inserted row ID when using AUTOINCREMENT pk (#17626) (d2e3b6e)
• update broken link to lock docs (#17563) (3754bda)
• update inquirer (#17540) (e34acec)
• update prettier to v3.3.3 (#17534) (7d2e72e)

Features

• replace correlated subquery with EXISTS (#17354) (4491353)

6.37.5 (2024-10-25)

Bug Fixes

• cast numbers in DataTypes.STRING to strings (#17564) (fce5ad3)

7.0.0-alpha.43 (2024-10-04)

Bug Fixes

• db2: remove unnecessary override (#17525) (9a51a05)
• mariadb: fix inefficient regular expression in error message (#17508) (3f5250b)
• mariadb: update mariadb to v3.3.2 (#17518) (3819cf5)
• mssql: update mssql to v18.6.1 (#17521) (b0ed3eb)
• mysql: update mysql2 to ^3.11.2 (#17498) (18ce1b0)
• snowflake: update snowflake to v1.14.0 (#17526) (41ae5c3)
• unify returning queries (#17157) (0a350c0)

Features

• respect position of inherited attributes (#17517) (691d90b)

6.37.4 (2024-10-04)

Bug Fixes

• oracle: add support for Oracle Database 23ai (#17345) (b9e71a7)
• oracle: validate input with TO_TIMESTAMP_TZ and TO_DATE (#17516) (5deadd2)

7.0.0-alpha.42 (2024-09-13)

Bug Fixes

• mssql: add ability to use instanceName in connection-manager config (#17432) (b2e0d69)

7.0.0-alpha.41 (2024-05-17)

Bug Fixes

• make BaseSqlExpression a unique class (#17158) (6a5ea6c)
• set sequelize dialect type in query generator and interface (#17285) (0227288)
• snowflake: add proxy connection options (#17309) (51b781e)

6.37.3 (2024-04-13)

Bug Fixes

• postgres: use schema for foreign key constrains of a table (#17099) (6aba382)

7.0.0-alpha.40 (2024-04-11)

Highlights

• Dialects have been moved to their own packages. Please see our upgrade guide to see how to initialize Sequelize

Bug Fixes

• parse the url option based on the dialect (#17252) (f05281c)
• update bulkDeleteQuery supported options (#17191) (c53fd01)

Features

• add ModelRepository#_UNSTABLE_bulkDestroy and manual ON DELETE handling (#17078) (45ac01a)
• cli: create @sequelize/cli as a replacement for sequelize-cli (#17195) (ec00aed)
• cli: add seed generate command (#17262) (b07ad40)
• db2: move db2 to the @sequelize/db2 package (#17197) (6aa4ced)
• move postgres to the @sequelize/postgres package (#17190) (721d560)
• mssql: upgrade to tedious 18 (#17137) (65e19a1)
• type options per dialect, add "url" option, remove alternative Sequelize constructor signatures (#17222) (b605bb3)
• mssql: move mssql to the @sequelize/mssql package (#17206) (8631f5a), closes #17206
• ibmi: move ibmi to the @sequelize/db2-ibmi package (#17209) (21772a5), closes #17209
• mysql: move mysql to the @sequelize/mysql package (#17202) (5c7830e), closes #17202
• mariadb: move mariadb to the @sequelize/mariadb package (#17198) (46ea159), closes #17198

BREAKING CHANGES

• db2, ibmi, snowflake and sqlite do not accept the url option anymore
• The sequelize constructor only accepts a single parameter: the option bag. All other signatures have been removed.
• Setting the sequelize option to a string representing a URL has been replaced with the "url" option.
• The dialectOptions option has been removed. All options that were previously in that object can now be set at the root of the option bag, like all other options.
• All dialect-specific options changed. This includes at least some credential options that changed.
• Which dialect-specific option can be used is allow-listed to ensure they do not break Sequelize
• The sequelize pool is not on the connection manager anymore. It is now directly on the sequelize instance and can be accessed via sequelize.pool
• The sequelize.config field has been removed. Everything related to connecting to the database has been normalized to sequelize.options.replication.write (always present) and sequelize.options.replication.read (only present if read-replication is enabled)
• sequelize.options is now fully frozen. It is no longer possible to modify the Sequelize options after the instance has been created.
• sequelize.options is a normalized list of option. If you wish to access the options that were used to create the sequelize instance, use sequelize.rawOptions
• The default sqlite database is not ':memory:' anymore, but sequelize.sqlite in your current working directory.
• Setting the sqlite database to a temporary database like ':memory:' or '' requires configuring the pool to behave like a singleton, and disallowed read replication
• The match option is no longer supported by sequelize.sync. If you made use of this feature, let us know so we can design a better alternative.
• The dialectModulePath has been fully removed to improve compatibility with bundlers.
• The dialectModule option has been split into multiple options. Each option is named after the npm library that is being replaced. For instance, @sequelize/postgres now accepts pgModule. @sequelize/mssql now accepts tediousModule
• Instead of installing the pg package, users need to install @sequelize/postgres.
• Instead of installing the tedious package, users need to install @sequelize/mssql.
• Instead of installing the odbc package, users need to install @sequelize/db-ibmi.
• Instead of installing mysql2, users need to install @sequelize/mysql.
• Instead of installing the mariadb package, users need to install @sequelize/mariadb.
• Instead of installing the ibm_db package, users need to install @sequelize/db2.
• Instead of installing the snowflake-sdk package, users need to install @sequelize/snowflake.