Bug Fixes

• add BaseEntity to model-shim (#10503) (3cf938e)
• add error handling for missing join columns (#10525) (122c897), closes #7034
• add missing export for View class (#10261) (7adbc9b)
• added fail callback while opening the database in Cordova (#10566) (8b4df5b)
• aggregate function throw error when column alias name is set (#10035) (022d2b5), closes #9927
• backport postgres connection error handling to crdb (#10177) (149226d)
• bump better-sqlite3 version range (#10452) (75ec8f2)
• caching always enabled not caching queries (#10524) (8af533f)
• circular dependency breaking node.js 20.6 (#10344) (ba7ad3c), closes #10338
• correctly keep query.data from ormOption for commit / rollback subscribers (#10151) (73ee70b)
• default value in child table/entity column decorator for multiple table inheritance is ignored for inherited columns (#10563) (#10564) (af77a5d)
• deletedAt column leaking as side effect of object update while creating a row (#10435) (7de4890)
• empty objects being hydrated when eager loading relations that have a @VirtualColumn (#10432) (b53e410), closes #10431
• extend GiST index with range types for Postgres driver (#10572) (a4900ae), closes #10567
• ignore changes for columns with update: false in persistence (#10250) (f8fa1fd), closes #10249
• improve helper for cli for commands missing positionals (#10133) (9f8899f)
• loading datasource unable to process a regular default export (#10184) (201342d), closes #8810
• logMigration has incorrect logging condition (#10323) (d41930f), closes #10322 #10322
• ManyToMany ER_DUP_ENTRY error (#10343) (e296063), closes #5704
• migrations on indexed TIMESTAMP WITH TIME ZONE Oracle columns (#10506) (cf37f13), closes #10493
• mongodb - undefined is not constructor (#10559) (ad5bf11)
• mongodb resolves leaked cursor (#10316) (2dc9624), closes #10315
• mssql datasource testonborrow not affecting anything (#10589) (122b683)
• nested transactions issues (#10210) (25e6ecd)
• prevent using absolute table path in migrations unless required (#10123) (dd59524)
• remove date-fns in favor of DayJs (#10306) (cf7147f)
• remove dynamic require calls (#10196) (a939654)
• resolve circular dependency when using Vite (#10273) (080528b)
• resolve issue building eager relation alias for nested relations (#10004) (c6f608d), closes #9944
• resolve issue of generating migration for numeric arrays repeatedly (#10471) (39fdcf6), closes #10043
• resolve issue queryBuilder makes different parameter identifiers for same parameter (#10327) (6c918ea), closes #7308
• resolve issues on upsert (#10588) (dc1bfed), closes #10587
• scrub all comment end markers from comments (#10163) (d937f61)
• serialize bigint when building a query id #10336 (#10337) (bfc1cc5)
• should automatically cache if alwaysEnable (#10137) (173910e), closes #9910
• SQLite simple-enum column parsing (#10550) (696e688)
• update UpdateDateColumn on upsert (#10458) (fdb9866), closes #9015
• upgrade ts-node version to latest(10.9.1) version (#10143) (fcb9904)
• using async datasource to configure typeorm (#10170) (fbd45db)

Features

• ability to change default replication mode (#10419) (72b1d1b)
• add concurrent indexes for postgres (#10442) (f4e6eaf)
• add exists and exists by (#10291) (b6b46fb)
• add isolated where statements (#10213) (3cda7ec)
• add MSSQL disableAsciiToUnicodeParamConversion option and tests (#10161) (df7c069), closes #10131
• add support for mssql server DefaultAzureCredential usage (#10246) (c8ee5b1)
• add support for table comment in MySQL (#10017) (338df16)
• allow to use custom type witch extends object type for find where argument (#10475) (48f5f85)
• BeforeQuery and AfterQuery events (#10234) (5c28154), closes #3302
• custom STI discriminator value for EntitySchema (#10508) (b240d87), closes #10494
• enabled CTE for oracle driver (#10319) (65858f3)
• entityId in InsertEvent (#10540) (ae006af)
• expose countDocuments in mongodb (#10314) (ebd61d1)
• exposed entity and criteria properties on EntityNotFoundError (#10202) (bafcd17)
• implement column comments for SAP HANA (#10502) (45e31cc)
• implement OR operator (#10086) (a00b1df), closes #10054 #10054 #10054 #10054 #10054 #10054 #10054
• implement streaming for SAP HANA (#10512) (7e9cead)
• implements QueryFailedError generic for driverError typing (#10253) (78b2f48)
• modify repository.extend method for chaining repositories (#10256) (ca29c0f)
• nullable embedded entities (#10289) (e67d704)
• support for MongoDB 6.x (#10545) (3647b26)
• support mssql@10 (#10356) (f6bb671), closes #10340
• use node-oracledb 6 (#10285) (3af891a), closes #10277
• user-defined index name for STI discriminator column (#10509) (89c5257), closes #10496

Performance Improvements

• improve SapQueryRunner performance (#10198) (f6b87e3)

BREAKING CHANGES

• With node-oracledb the thin client is used as default. Added a option to use the thick client. Also added the option to specify the instant client lib
• MongoDB: from the previous behavior of returning a result with metadata describing when a document is not found. See: https://github.com/mongodb/node-mongodb-native/blob/HEAD/etc/notes/CHANGES_6.0.0.md
• new nullable embeds feature introduced a breaking change which might enforce you to update types on your entities to | null, if all columns in your embed entity are nullable. Since database queries now return embedded property as null if all its column values are null.