6.2.1 (2024-04-12)

Bug Fixes

• core: skip 1:1 owner auto-joins for lazy properties (6442e57)
• knex: rework postgres and mysql dialect imports to fix compilation errors (ffdca15)
• mssql: support instance names in host (dc7dc4c), closes #5441
• query-builder: do not ignore unmatching partial loading hints in qb.joinAndSelect (ccdf018), closes #5445
• query-builder: fix partial loading via qb.joinAndSelect with explicit aliasing (da68503), closes #5445
• query-builder: generate join on condition for subquery joins with known property name (3dfbbde), closes #5445
• query-builder: respect collection property where conditions (declarative partial loading) (3b4fc41), closes #5445

6.2.0 (2024-04-09)

https://mikro-orm.io/blog/mikro-orm-6-2-released

Bug Fixes

• core: do not select 1:1 owning FK twice (fa69276)
• core: fix querying by embedded properties inside relations (2e74699), closes #5391
• core: fix support for custom repositories in @CreateRequestContext on type level (aacac83)
• core: fix TypeError when ordering by embedded populating properties (2c472ab), closes #5389
• core: ignore current context when creating repository instance (4c12fc5), closes #5395
• core: prefer entity type inference from the first parameter of entity manager methods (523963b)
• core: respect custom EntityManager type in em.fork() (bb1a3f9), closes #5415
• core: support passing Configuration instance to MikroORM.init (54a37d0), closes #5413
• entity-generator: allow arbitrary class and prop names as identifiers (#5359) (b0c0236)
• mariadb: rework pagination mechanism to fix extra results (a57cb19)
• mysql: support order by nulls first/last for raw query fragments in order by keys (a2a8f0d)
• postgres: drop text enum check constraints only when necessary (#5414) (5162345), closes #4112
• postgres: removed erroneous duplicates in FK discovery query (#5376) (eec2b38)
• query-builder: fix serialization hint of nested qb.joinAndSelect() calls (c2843b9)
• schema: improve detection of renamed columns (4d13c58)
• schema: rework dropping columns to support custom schemas and merge drop column queries (255f425)

Features

• core: add support for serialization groups (#5416) (818c290)
• core: allow better type-safety for custom types via IType (#5383) (0e18346)
• core: allow configuring driverOptions on replica level (05e81f8)
• core: include all dirty collections to UoW.getCollectionUpdates() (e7bd66f)
• core: make assign options configurable globally (bc9f6f5), closes #5410
• libsql: add libSQL driver (#5417) (6c63e4b), closes #5283
• mssql: add MS SQL Server driver (#1375) (eeaad45), closes #771
• postgres: allow defining deferred FK constraints (#5384) (f42d171), closes #5306
• query-builder: add limit 1 when executing query via getSingleResult() or execute('get') (c2b22e8), closes #5379
• query-builder: add qb.getLoggerContext() and qb.setLoggerContext() (779fa15), closes #5358
• schema: allow configuring updateRule and deleteRule for pivot tables (cc69c3c)
• schema: improve orm.schema.execute() to support executing batches (3c5a347)
• schema: support recreating the whole database via orm.schema.refreshDatabase() (2e4ab49)

Performance Improvements

• core: optimize metadata discovery (c322f9b)
• query-builder: remove unnecessary join branches when pagination is applied (d228976)

6.1.12 (2024-03-24)

Bug Fixes

• core: fix assignability of partially loaded entities (9de4965), closes #5374
• core: fix inlining of $and conditions (8ddb3e4), closes #5368
• entity-generator: try to resolve errors for foreign keys without indexes (f2094ab), closes #5364
• postgres: fix query for loading all foreign keys from existing schema (2eb85d5), closes #5364
• reflection: fallback to not proving path to tsconfig if not found (a24d80d)

Features

• cli: add reason for failed connection check in debug command (d61e248)
• core: allow passing EntityManager or EntityRepository to @CreateRequestContext decorator (184cdd4)
• postgres: add ?, ?| and ?& json operators (#5366) (6418872), closes #4678

Performance Improvements

• postgres: try to optimize loading of foreign keys (2dff96b), closes #5364

6.1.11 (2024-03-18)

Bug Fixes

• core: improve serialization of lazily partially loaded entities (1c7b446), closes #5139
• core: support unsetting composite FKs via flush (64f2afd)
• migrator: type mismatch between Migration interface and class (#5343) (2fba5ee), closes #5340
• query-builder: fix aliasing of FK when used in deeply nested and/or conditions (ebb966c), closes #5086
• reflection: respect custom tsconfig options (e8cfdc0)
• sql: fix aliasing of nested composite FK queries (60b2c91)

6.1.10 (2024-03-14)

Bug Fixes

• core: detect ts-node when using esm loader (#5332) (23cc880)
• core: don't alias formulas in update/delete queries (9e35642), closes #5334
• core: fix populating references for 1:m collections (9b9027d), closes #5336
• core: fix value of hasPrev[/Next]Page when paginating backwards (#5320) (00239eb)
• postgres: fix diffing of native enums (create/remove via schema:update) (7c8be79), closes #5322
• query-builder: allow joining object/array properties (fd90bae), closes #5325
• query-builder: fix join on conditions where or operator (92936ef)
• schema: support compound index over JSON property and a regular column (319df49), closes #5333
• sql: allow creating query builder from a global context (9217bb3)
• sql: override FK value when it's disallowed by query condition (0d20847)

Features

• core: add onlyOwnProperties option to assign helper (#5330) (a081bea), closes #5327
• postgres: provide more details in driver exceptions (e782d06)

Performance Improvements

• core: disable change tracking on scalars when flushMode is not auto (fc30bfe)

6.1.9 (2024-03-10)

Bug Fixes

• core: don't propagate changes from em.transactional() to upper context if its global (7ac9a19), closes #5309
• core: ignore filters on relations inside embedded properties (1e4b2ce), closes #5310
• core: improve checks for generated columns (0396e1e)
• core: map virtual relations with persist: false as formulas to preserve aliasing (20a4cfb)
• entity-generator: emit missing imports in EntitySchema generated files (#5311) (f680d66)
• entity-generator: output type import statements for type only core imports (#5317) (bd3f160)
• migrator: allow up and down methods to be synchronous (#5316) (dd6daf9)

Features

• postgres: add support for native enum arrays (c2e362b), closes #5322

6.1.8 (2024-03-06)

Bug Fixes

• core: allow setting values to null on unloaded references (1cbead6), closes #5274
• core: fix bulk-inserting entities with nullable embedded arrays (f16551e)
• core: skip STI discriminator condition when bulk-deleting entities (fa712ca), closes #5303
• query-builder: fix qb.getResultAndCount() when pagination is triggered (67444c0)

6.1.7 (2024-03-04)

Bug Fixes

• core: add em.addFilter() fallback signature that allows more than 3 types (b6efd44)
• core: fix aliasing of queries with collection operators (0435faf), closes #5301
• core: ignore collection operators in populateWhere conditions (7b6b363)
• query-builder: check for duplicate selects when wrapping pagination query (e005cc2)
• query-builder: fix cloning of alias map (50d8fb9)

Features

• core: validate wrong placement of collection operators (c35e705)

6.1.6 (2024-02-28)

Bug Fixes

• core: don't refresh collection state via Collection.load() (f5be639), closes #5268
• core: fix type of options parameter in repository.upsert/Many() (4c12e7f)
• core: support raw fragments in orderBy of 1:m and m:n relations (ed80163), closes #5277
• mysql: apply current context when fetching auto_increment_increment (#5280) (c8021da), closes #5279

Performance Improvements

• core: improve composite PK hashing (73094ef)
• core: improve hydration of simple FKs (c4bd1f0)
• core: optimize adding entities to large collections (8a960d5)

6.1.5 (2024-02-21)

Bug Fixes

• core: allow serializing raw SQL fragments outside of entity serialization (9158f51), closes #5257
• core: ensure missing type validation ignores enums (a916710), closes #5255
• core: fix orderBy option on to-many properties with arrays (fae2302), closes #5265
• core: ignore virtual properties in partial loading hint (d327db5), closes #5261
• entity-generator: fixed generation of unsigned columns (#5254) (d78da29)
• entity-generator: optional and hidden properties get type option + string defaults (#5264) (12d3b54), closes #5260
• schema: allow 1:m properties in pivot entities (c370578)