Version: 7.0

Changelog

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

7.0.1 (2026-03-11)

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

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)