Skip to main content
Version: 7.0

Changelog

All notable changes to this project will be documented in this file. See Conventional Commits for commit guidelines.

7.0.7 (2026-03-31)​

Bug Fixes​

  • mssql: use equality conditions for composite PK batch updates (#7442) (ba4063b)
  • sql: fix count queries with composite PKs and toMany joins (#7415) (bb0d66c), closes #7414
  • sql: fix nativeEnumName schema handling with config-level schema (#7435) (2ddd288), closes #7432
  • sql: generate indexes for materialized view entities (#7419) (bf86941), closes #7417
  • sql: infer Kysely table names for classes extending defineEntity().class (#7425) (469a667), closes #7423
  • sql: pass transaction context through schema introspection to avoid deadlock (#7426) (2a1bc05), closes #7424
  • sql: resolve alias placeholder in raw fragments used as operator values (#7427) (d23d30b), closes #7422

7.0.6 (2026-03-26)​

Bug Fixes​

  • schema: escape single quotes in enum CHECK constraints (#7396) (3656519), closes #7395

7.0.5 (2026-03-23)​

Bug Fixes​

  • sql: infer FK columns for decorator entities in getKysely types (#7368) (81068f3), closes #7367
  • sql: use column name mapping for decorator entities in getKysely types (#7369) (d3baa56), closes #7367

7.0.4 (2026-03-20)​

Bug Fixes​

  • sql: accept custom types in QueryBuilder operators for joined entities (#7342) (0aaafbf), closes #7341
  • sql: prune redundant joins in pagination outer query (#7339) (48acce9), closes #6681

Features​

  • postgresql: generate check constraints for enum array columns (#7356) (ec10597), closes #7352

7.0.3 (2026-03-18)​

Bug Fixes​

  • core: provide intellisense for fields hint in find options (#7325) (4383d9b)
  • postgres: handle native enum arrays in non-default schemas (#7330) (71a1014), closes #7318
  • schema: handle SELECT * expansion in view schema diffing (#7313) (3a05128), closes #7308
  • sql: convert undefined FK values to null in batch updates (#7334) (b2240eb)
  • sql: fix polymorphic relations with default filters on target entities (#7332) (40777d2), closes #7317
  • sql: fix populating TPT relations with embeddables or custom types in child entities (#7331) (5fc6311), closes #7329

7.0.2 (2026-03-14)​

Bug Fixes​

  • schema: handle multiline view expressions in SQLite schema diffing (#7294) (2a2ed10), closes #7292

7.0.1 (2026-03-11)​

Bug Fixes​

  • update peer dependency constraints to v7 and pin on release (fbeace5)

7.0.0 (2026-03-11)​

Bug Fixes​

  • query-builder: apply WHERE conditions to ORDER BY joins in paginated queries (128e58b), closes #6160
  • schema: disable FK checks by default only for orm.schema.clear() in MySQL (c0d942d)
  • schema: do not ignore changes to entity level comments (4087704), closes #7187
  • schema: do not infer nullability of to-one relations based on cascade option (56be7f3), closes #6972
  • sql: always alias virtual properties in where query (37f35af), closes #7196
  • sql: cross-schema JOINs no longer inherit main entity's schema (#7250) (07852fc)
  • sql: fix populating M:N relations with pivotEntity that uses mapToPk: true (cdd8f85), closes #7107
  • sql: handle $not operator inside relation filters (#7226) (b002e16)
  • sql: ignore missing tables during schema clear (8f90f07)
  • sql: qualify cross-schema FK references with dbName on MySQL/MariaDB (#7251) (489d2b9)
  • sql: skip pagination subquery and force balanced strategy for virtual entities (e2c1287), closes #7195

Features​

  • kysely: add MikroKyselyPlugin to support various ORM features with kysely (#6998) (d01d93b)
  • query-builder: add support for common table expressions (CTE) (#7231) (ebd0d43)
  • schema: add native support for advanced index features (#7160) (a2330d2)
  • schema: allow changing defaults for update/deleteRule and remove inference from cascade option (#7115) (dd6a226)
  • schema: allow skipping views (#7150) (be74bf9)
  • sql: add $elemMatch operator for JSON array properties (#7265) (e40a275)
  • sql: improve QueryBuilder type safety with context-aware types (#7138) (631e351)
  • sql: infer Database for kysely (#6939) (8f8ada5)
  • sql: replace knex with kysely (#6400) (2a0384e)
  • sql: replace knex with native implementation of query and schema building (#6358) (c8471ca)
  • sql: strictly type SelectQueryBuilder.execute() return type (#7200) (1e15042)
  • sql: support aliasing formula and regular properties in QueryBuilder select (#7190) (6d8da38)
  • sql: support UNION-based where clauses as index-friendly alternative to $or (#7214) (1e8a674)
  • sql: transparent querying of embedded array properties (#7264) (c9f13bb)
Page Options