typeorm/typeorm
### [`v0.2.45`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0245-httpsgithubcomtypeormtypeormcompare02440245-2022-03-04)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.44...0.2.45)
##### Bug Fixes
- allow clearing database inside a transaction ([#8712](https://togithub.com/typeorm/typeorm/issues/8712)) ([f3cfdd2](https://togithub.com/typeorm/typeorm/commit/f3cfdd264105ba8cf1c92832b4b95e5a3ca0ed09)), closes [#8527](https://togithub.com/typeorm/typeorm/issues/8527)
- discard duplicated columns on update ([#8724](https://togithub.com/typeorm/typeorm/issues/8724)) ([0fc093d](https://togithub.com/typeorm/typeorm/commit/0fc093d168b54a0fd99bb411a730aad9be1858ac)), closes [#8723](https://togithub.com/typeorm/typeorm/issues/8723)
- fix entityManager.getId for custom join table ([#8676](https://togithub.com/typeorm/typeorm/issues/8676)) ([33b2bd7](https://togithub.com/typeorm/typeorm/commit/33b2bd7acc55d6eb30bfe0681748d6b6abaff0b5)), closes [#7736](https://togithub.com/typeorm/typeorm/issues/7736)
- force web bundlers to ignore index.mjs and use the browser ESM version directly ([#8710](https://togithub.com/typeorm/typeorm/issues/8710)) ([411fa54](https://togithub.com/typeorm/typeorm/commit/411fa54368c8940e94b1cbf7ab64b8d5377f9406)), closes [#8709](https://togithub.com/typeorm/typeorm/issues/8709)
##### Features
- add nested transaction ([#8541](https://togithub.com/typeorm/typeorm/issues/8541)) ([6523526](https://togithub.com/typeorm/typeorm/commit/6523526003bab74a0df8f7d578790c1728b26057)), closes [#1505](https://togithub.com/typeorm/typeorm/issues/1505)
- add transformer to ViewColumnOptions ([#8717](https://togithub.com/typeorm/typeorm/issues/8717)) ([96ac8f7](https://togithub.com/typeorm/typeorm/commit/96ac8f7eece06ae0a8b52ae7da740c92c0c0d4b9))
### [`v0.2.44`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0244-httpsgithubcomtypeormtypeormcompare02430244-2022-02-23)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.43...0.2.44)
##### Bug Fixes
- alter relation loader to use transforms when present ([#8691](https://togithub.com/typeorm/typeorm/issues/8691)) ([2c2fb29](https://togithub.com/typeorm/typeorm/commit/2c2fb29a67bfd0ca7dd9133a2f85f5b4db5fb195)), closes [#8690](https://togithub.com/typeorm/typeorm/issues/8690)
- cannot read properties of undefined (reading 'joinEagerRelations') ([136015b](https://togithub.com/typeorm/typeorm/commit/136015b04ee72b0ca2439fbff53b1467c12c24b6))
- expo driver doesn't work properly because of new beforeMigration() afterMigration() callbacks ([#8683](https://togithub.com/typeorm/typeorm/issues/8683)) ([5a71803](https://togithub.com/typeorm/typeorm/commit/5a7180378e34ab58ad40c504ebc5195e2413c5f4))
- ng webpack default import ([#8688](https://togithub.com/typeorm/typeorm/issues/8688)) ([2d3374b](https://togithub.com/typeorm/typeorm/commit/2d3374b3b4cb8163764c035bd687b2c81787f338)), closes [#8674](https://togithub.com/typeorm/typeorm/issues/8674)
- support imports of absolute paths of ESM files on Windows ([#8669](https://togithub.com/typeorm/typeorm/issues/8669)) ([12cbfcd](https://togithub.com/typeorm/typeorm/commit/12cbfcde7bc4f56069ed3298064bb91ad0816bf0)), closes [#8651](https://togithub.com/typeorm/typeorm/issues/8651)
##### Features
- add option to upsert to skip update if the row already exists and no values would be changed ([#8679](https://togithub.com/typeorm/typeorm/issues/8679)) ([8744395](https://togithub.com/typeorm/typeorm/commit/87443954b59768ab77fb15097ea9d88822b4a733))
- allow `{delete,insert}().returning()` on MariaDB ([#8673](https://togithub.com/typeorm/typeorm/issues/8673)) ([7facbab](https://togithub.com/typeorm/typeorm/commit/7facbabd2663098156a53983ea38433ed39082d2)), closes [#7235](https://togithub.com/typeorm/typeorm/issues/7235) [#7235](https://togithub.com/typeorm/typeorm/issues/7235)
- Implement deferrable foreign keys for SAP HANA ([#6104](https://togithub.com/typeorm/typeorm/issues/6104)) ([1f54c70](https://togithub.com/typeorm/typeorm/commit/1f54c70b76de34d4420904b72137df746ea9aaed))
### [`v0.2.43`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0243-httpsgithubcomtypeormtypeormcompare02420243-2022-02-17)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.42...0.2.43)
##### Bug Fixes
- support `require` to internal files without explicitly writing `.js` in the path ([#8660](https://togithub.com/typeorm/typeorm/issues/8660)) ([96aed8a](https://togithub.com/typeorm/typeorm/commit/96aed8aae06df0ae555aa51ed9f1a5ffec141e61)), closes [#8656](https://togithub.com/typeorm/typeorm/issues/8656)
##### Features
- embedded entities with entity schema ([#8626](https://togithub.com/typeorm/typeorm/issues/8626)) ([7dbe956](https://togithub.com/typeorm/typeorm/commit/7dbe956c56da3a430ae6f0e99730e9449deae889)), closes [#3632](https://togithub.com/typeorm/typeorm/issues/3632)
##### Reverts
- Revert "feat: soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436))" ([#8654](https://togithub.com/typeorm/typeorm/issues/8654)) ([6b0b15b](https://togithub.com/typeorm/typeorm/commit/6b0b15b0e68584ed7cd81a658d8606cfdb96817c)), closes [#8436](https://togithub.com/typeorm/typeorm/issues/8436) [#8654](https://togithub.com/typeorm/typeorm/issues/8654)
### [`v0.2.42`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0242-httpsgithubcomtypeormtypeormcompare02410242-2022-02-16)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.41...0.2.42)
##### Bug Fixes
- proper column comment mapping from database to metadata in aurora-data-api ([baa5880](https://togithub.com/typeorm/typeorm/commit/baa5880001064333eb4eb01765b1d79e17cf1fb5))
- add referencedSchema to PostgresQueryRunner ([#8566](https://togithub.com/typeorm/typeorm/issues/8566)) ([c490319](https://togithub.com/typeorm/typeorm/commit/c49031929aca8f3b932c6593b75447256085bfef))
- adding/removing [@Generated](https://togithub.com/Generated)() will now generate a migration to add/remove the DEFAULT value ([#8274](https://togithub.com/typeorm/typeorm/issues/8274)) ([4208393](https://togithub.com/typeorm/typeorm/commit/42083936e2b65f0d1bd8e23d12689a7f49e2da2f)), closes [#5898](https://togithub.com/typeorm/typeorm/issues/5898)
- adds entity-schema support for createForeignKeyConstraints ([#8606](https://togithub.com/typeorm/typeorm/issues/8606)) ([f224f24](https://togithub.com/typeorm/typeorm/commit/f224f24e5247d3c42385bfc03c89f518aa932310)), closes [#8489](https://togithub.com/typeorm/typeorm/issues/8489)
- allow special keyword as column name for simple-enum type on sqlite ([#8645](https://togithub.com/typeorm/typeorm/issues/8645)) ([93bf96e](https://togithub.com/typeorm/typeorm/commit/93bf96ea635823c7933ea8ef7326be62ccdd6ea7))
- correctly handle multiple-row insert for SAP HANA driver ([#7957](https://togithub.com/typeorm/typeorm/issues/7957)) ([8f2ae71](https://togithub.com/typeorm/typeorm/commit/8f2ae71201e7738fe3c1efd5bbc4584dfe62dcc0))
- disable SQLite FK checks in synchronize / migrations ([#7922](https://togithub.com/typeorm/typeorm/issues/7922)) ([f24822e](https://togithub.com/typeorm/typeorm/commit/f24822ef9cb3051fbe9f3fd5d9e669788852c5a5))
- find descendants of a non-existing tree parent ([#8557](https://togithub.com/typeorm/typeorm/issues/8557)) ([cbb61eb](https://togithub.com/typeorm/typeorm/commit/cbb61eb08139204479110c88d7d1849a24080d11)), closes [#8556](https://togithub.com/typeorm/typeorm/issues/8556)
- For MS SQL Server use lowercase "sys"."columns" reference. ([#8400](https://togithub.com/typeorm/typeorm/issues/8400)) ([#8401](https://togithub.com/typeorm/typeorm/issues/8401)) ([e8a0f92](https://togithub.com/typeorm/typeorm/commit/e8a0f921b4baa7aa7e55ac1fd34c449dfa1e3229))
- improve DeepPartial type ([#8187](https://togithub.com/typeorm/typeorm/issues/8187)) ([b93416d](https://togithub.com/typeorm/typeorm/commit/b93416d7bc25006b34a90c14c497cc7e6e57e28c))
- Lock peer dependencies versions ([#8597](https://togithub.com/typeorm/typeorm/issues/8597)) ([600bd4e](https://togithub.com/typeorm/typeorm/commit/600bd4e5da74b012409d1fdf411a0a0b5265466b))
- make EntityMetadataValidator comply with entitySkipConstructor, cover with test ([#8445](https://togithub.com/typeorm/typeorm/issues/8445)) ([3d6c5da](https://togithub.com/typeorm/typeorm/commit/3d6c5dae76ad0e0640650058ae58fe0addda2ae6)), closes [#8444](https://togithub.com/typeorm/typeorm/issues/8444)
- materialized path being computed as "undefined1." ([#8526](https://togithub.com/typeorm/typeorm/issues/8526)) ([09f54e0](https://togithub.com/typeorm/typeorm/commit/09f54e0273be4dc836824a38e9c78b50ad21bba6))
- MongoConnectionOptions sslCA type mismatch ([#8628](https://togithub.com/typeorm/typeorm/issues/8628)) ([02400da](https://togithub.com/typeorm/typeorm/commit/02400dab662aceca9a722c4aa0dd74a9fa2cb90d))
- mongodb repository.find filters soft deleted rows ([#8581](https://togithub.com/typeorm/typeorm/issues/8581)) ([f7c1f7d](https://togithub.com/typeorm/typeorm/commit/f7c1f7d7c0481f4ada506e5b811a3219519eadf9)), closes [#7113](https://togithub.com/typeorm/typeorm/issues/7113)
- mongodb@4 compatibility support ([#8412](https://togithub.com/typeorm/typeorm/issues/8412)) ([531013b](https://togithub.com/typeorm/typeorm/commit/531013b2f8dfb8d04b0bfb844dc83a5ba6404569))
- must invoke key pragma before any other interaction if SEE setted ([#8478](https://togithub.com/typeorm/typeorm/issues/8478)) ([546b3ed](https://togithub.com/typeorm/typeorm/commit/546b3ed8886c44fbe3d9e167d1904cb9e5961df7)), closes [#8475](https://togithub.com/typeorm/typeorm/issues/8475)
- nested eager relations in a lazy-loaded entity are not loaded ([#8564](https://togithub.com/typeorm/typeorm/issues/8564)) ([1cfd7b9](https://togithub.com/typeorm/typeorm/commit/1cfd7b98ba27032dd0e9429a245c40cea47900f7))
- QueryFailedError when tree entity with JoinColumn ([#8443](https://togithub.com/typeorm/typeorm/issues/8443)) ([#8447](https://togithub.com/typeorm/typeorm/issues/8447)) ([a11c50d](https://togithub.com/typeorm/typeorm/commit/a11c50d5519bda1410ab9ccf67bfcb12ef109c61))
- relation id and afterAll hook performance fixes ([#8169](https://togithub.com/typeorm/typeorm/issues/8169)) ([31f0b55](https://togithub.com/typeorm/typeorm/commit/31f0b5535aa0cc49ff23610b1924c03432f5461f))
- replaced custom uuid generator with `uuid` library ([#8642](https://togithub.com/typeorm/typeorm/issues/8642)) ([8898a71](https://togithub.com/typeorm/typeorm/commit/8898a7175f481f1c171acefef61dc089bc3f8a8e))
- single table inheritance returns the same discriminator value error for unrelated tables where their parents extend from the same entity ([#8525](https://togithub.com/typeorm/typeorm/issues/8525)) ([6523fcc](https://togithub.com/typeorm/typeorm/commit/6523fccda1147dc697afbba57792e5cb4165fbf2)), closes [#8522](https://togithub.com/typeorm/typeorm/issues/8522)
- updating with only `update: false` columns shouldn't trigger [@UpdateDateColumn](https://togithub.com/UpdateDateColumn) column updation ([2834729](https://togithub.com/typeorm/typeorm/commit/2834729e80577bd30f09c2c0e4c949cde173bba3)), closes [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394)
- upsert should find unique index created by one-to-one relation ([#8618](https://togithub.com/typeorm/typeorm/issues/8618)) ([c8c00ba](https://togithub.com/typeorm/typeorm/commit/c8c00baf9351973be5780687418303dd87de2077))
##### Features
- add comment param to FindOptions ([#8545](https://togithub.com/typeorm/typeorm/issues/8545)) ([ece0da0](https://togithub.com/typeorm/typeorm/commit/ece0da027dfce4357764dda4b810598ad64af9d9))
- add custom timestamp option in migration creation ([#8501](https://togithub.com/typeorm/typeorm/issues/8501)) ([4a7f242](https://togithub.com/typeorm/typeorm/commit/4a7f2420f1b498465b2a5913b7d848b3eaafb113)), closes [#8500](https://togithub.com/typeorm/typeorm/issues/8500) [#8500](https://togithub.com/typeorm/typeorm/issues/8500)
- add support for node-redis v4.0.0 and newer ([#8425](https://togithub.com/typeorm/typeorm/issues/8425)) ([0626ed1](https://togithub.com/typeorm/typeorm/commit/0626ed1f0bd75fb8e72a462593f33813d85faee8))
- add support for Postgres 10+ GENERATED ALWAYS AS IDENTITY ([#8371](https://togithub.com/typeorm/typeorm/issues/8371)) ([a0f09de](https://togithub.com/typeorm/typeorm/commit/a0f09de8400ac7c94df33f8213ef0eec79b9239d)), closes [#8370](https://togithub.com/typeorm/typeorm/issues/8370)
- add WITH (lock) clause for MSSQL select with join queries ([#8507](https://togithub.com/typeorm/typeorm/issues/8507)) ([3284808](https://togithub.com/typeorm/typeorm/commit/3284808b63552d81456752187c0d130db76007ed)), closes [#4764](https://togithub.com/typeorm/typeorm/issues/4764)
- adds entity-schema support for withoutRowid ([#8432](https://togithub.com/typeorm/typeorm/issues/8432)) ([bd22dc3](https://togithub.com/typeorm/typeorm/commit/bd22dc3b8175ef82967b8265a2388ce16cc08623)), closes [#8429](https://togithub.com/typeorm/typeorm/issues/8429)
- allow soft-deletion of orphaned relation rows using orphanedRow… ([#8414](https://togithub.com/typeorm/typeorm/issues/8414)) ([cefddd9](https://togithub.com/typeorm/typeorm/commit/cefddd95c550191d6a18cb53c8ea4995d0c219ca))
- custom name for typeorm_metadata table ([#8528](https://togithub.com/typeorm/typeorm/issues/8528)) ([f8154eb](https://togithub.com/typeorm/typeorm/commit/f8154eb4c5089a1a0d2c2073f0ea5d64b3252e08)), closes [#7266](https://togithub.com/typeorm/typeorm/issues/7266)
- deferrable option for Unique constraints (Postgres) ([#8356](https://togithub.com/typeorm/typeorm/issues/8356)) ([e52b26c](https://togithub.com/typeorm/typeorm/commit/e52b26c910047d22aa3ea003b62d11c2bf352249))
- ESM support ([#8536](https://togithub.com/typeorm/typeorm/issues/8536)) ([3a694dd](https://togithub.com/typeorm/typeorm/commit/3a694dd3e99699e7284709c53967a5dfcb1e1806)), closes [#6974](https://togithub.com/typeorm/typeorm/issues/6974) [#6941](https://togithub.com/typeorm/typeorm/issues/6941) [#7516](https://togithub.com/typeorm/typeorm/issues/7516) [#7159](https://togithub.com/typeorm/typeorm/issues/7159)
- query builder negating with "NotBrackets" for complex expressions ([#8476](https://togithub.com/typeorm/typeorm/issues/8476)) ([fe7f328](https://togithub.com/typeorm/typeorm/commit/fe7f328fd5b918cab2e7301d57c62e81d9ff34f3))
- separate update events into update, soft-remove, and recover ([#8403](https://togithub.com/typeorm/typeorm/issues/8403)) ([93383bd](https://togithub.com/typeorm/typeorm/commit/93383bd2ee6dc8c22a5cfc0021334fe199da81dc)), closes [#8398](https://togithub.com/typeorm/typeorm/issues/8398)
- soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436)) ([d0f32b3](https://togithub.com/typeorm/typeorm/commit/d0f32b3a17be9ffe9fbc6112e5731bbac91c3691))
- sqlite attach ([#8396](https://togithub.com/typeorm/typeorm/issues/8396)) ([9e844d9](https://togithub.com/typeorm/typeorm/commit/9e844d9ff72fae72578399e24464cd7912c0fe5e))
##### Reverts
- migration:show command must exist with zero status code (Fixes [#7349](https://togithub.com/typeorm/typeorm/issues/7349)) ([#8185](https://togithub.com/typeorm/typeorm/issues/8185)) ([e0adeee](https://togithub.com/typeorm/typeorm/commit/e0adeee48eeb0d5412aa5c0258f7c12e6b1c38ed))
##### BREAKING CHANGES
- update listeners and subscriber no longer triggered by soft-remove and recover
### [`v0.2.41`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0241-httpsgithubcomtypeormtypeormcompare02400241-2021-11-18)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.40...0.2.41)
##### Bug Fixes
- add `retryWrites` to `MongoConnectionOptions` ([#8354](https://togithub.com/typeorm/typeorm/issues/8354)) ([c895680](https://togithub.com/typeorm/typeorm/commit/c895680dce35f0550f48d92d7dd1a5fb48ab4135)), closes [#7869](https://togithub.com/typeorm/typeorm/issues/7869)
- create typeorm_metadata table when running migrations ([#4956](https://togithub.com/typeorm/typeorm/issues/4956)) ([b2c8168](https://togithub.com/typeorm/typeorm/commit/b2c8168514b23671080e6d384e381e997fbaa11e))
- db caching won't work with replication enabled ([#7694](https://togithub.com/typeorm/typeorm/issues/7694)) ([2d0abe7](https://togithub.com/typeorm/typeorm/commit/2d0abe7140a0aec40d50c15acd98633483db3e29)), closes [#5919](https://togithub.com/typeorm/typeorm/issues/5919)
- incorrect composite `UNIQUE` constraints detection ([#8364](https://togithub.com/typeorm/typeorm/issues/8364)) ([29cb891](https://togithub.com/typeorm/typeorm/commit/29cb89123aaf705437927a8c6ed23204422b71cc)), closes [#8158](https://togithub.com/typeorm/typeorm/issues/8158)
- Postgres enum generates unnecessary queries on schema sync ([#8268](https://togithub.com/typeorm/typeorm/issues/8268)) ([98d5f39](https://togithub.com/typeorm/typeorm/commit/98d5f39e35b6e5dd77ae2aa60f80f4ac98249379))
- resolve issue delete column null on after update event subscriber ([#8318](https://togithub.com/typeorm/typeorm/issues/8318)) ([8a5e671](https://togithub.com/typeorm/typeorm/commit/8a5e6715e2d32da22c2fa71a14a7cf1fe897a159)), closes [#6327](https://togithub.com/typeorm/typeorm/issues/6327)
##### Features
- export interfaces from schema-builder/options ([#8383](https://togithub.com/typeorm/typeorm/issues/8383)) ([7b8a1e3](https://togithub.com/typeorm/typeorm/commit/7b8a1e38f269ba329a153135e12e1a21274b3a18))
- implement generated columns for postgres 12 driver ([#6469](https://togithub.com/typeorm/typeorm/issues/6469)) ([91080be](https://togithub.com/typeorm/typeorm/commit/91080be0cd35a5ee9467d4b50b6b7fb5421ac800))
- lock modes in cockroachdb ([#8250](https://togithub.com/typeorm/typeorm/issues/8250)) ([d494fcc](https://togithub.com/typeorm/typeorm/commit/d494fccc9c6a2d773bcb411ba746a74539373eff)), closes [#8249](https://togithub.com/typeorm/typeorm/issues/8249)
### [`v0.2.40`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0240-httpsgithubcomtypeormtypeormcompare02390240-2021-11-11)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.39...0.2.40)
##### Bug Fixes
- BaseEntity finder methods to properly type-check lazy relations conditions ([#5710](https://togithub.com/typeorm/typeorm/issues/5710)) ([0665ff5](https://togithub.com/typeorm/typeorm/commit/0665ff5473d075e442f3a93f665bbe087bdf29de))
##### Features
- add depth limiter optional parameter when loading nested trees using TreeRepository's findTrees() and findDescendantsTree() ([#7926](https://togithub.com/typeorm/typeorm/issues/7926)) ([0c44629](https://togithub.com/typeorm/typeorm/commit/0c44629c83c48c27448e7e3cb39faf26994e6e56)), closes [#3909](https://togithub.com/typeorm/typeorm/issues/3909)
- add upsert methods for the drivers that support onUpdate ([#8104](https://togithub.com/typeorm/typeorm/issues/8104)) ([3f98197](https://togithub.com/typeorm/typeorm/commit/3f981975d4347483937547feaa8fa4f63b81a83c)), closes [#2363](https://togithub.com/typeorm/typeorm/issues/2363)
- Postgres IDENTITY Column support ([#7741](https://togithub.com/typeorm/typeorm/issues/7741)) ([969af95](https://togithub.com/typeorm/typeorm/commit/969af958ba27282b9594140a7e2d58dba1192830))
##### Reverts
- "feat: use char(36) for uuid representation in mysql ([#7853](https://togithub.com/typeorm/typeorm/issues/7853))" ([#8343](https://togithub.com/typeorm/typeorm/issues/8343)) ([1588c58](https://togithub.com/typeorm/typeorm/commit/1588c58539e5121dad6b7120f0b5f83f43f1532f))
- regression in ordering by the relation property ([#8346](https://togithub.com/typeorm/typeorm/issues/8346)) ([#8352](https://togithub.com/typeorm/typeorm/issues/8352)) ([0334d10](https://togithub.com/typeorm/typeorm/commit/0334d104d9ce93c8cb079449ce98ffbdc64219c2)), closes [#3736](https://togithub.com/typeorm/typeorm/issues/3736) [#8118](https://togithub.com/typeorm/typeorm/issues/8118)
### [`v0.2.39`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0239-httpsgithubcomtypeormtypeormcompare02380239-2021-11-09)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.38...0.2.39)
##### Bug Fixes
- attach FOR NO KEY UPDATE lock to query if required ([#8008](https://togithub.com/typeorm/typeorm/issues/8008)) ([9692930](https://togithub.com/typeorm/typeorm/commit/96929302a4dc27a19e94c5532a3ae76951e52552)), closes [#7717](https://togithub.com/typeorm/typeorm/issues/7717)
- cli should accept absolute paths for --config ([4ad3a61](https://togithub.com/typeorm/typeorm/commit/4ad3a61037ad9ead998665d2857d6e4725d7b718))
- create a different cacheId if present for count query in getManyAndCount ([#8283](https://togithub.com/typeorm/typeorm/issues/8283)) ([9f14e48](https://togithub.com/typeorm/typeorm/commit/9f14e488281fb08d8ea1a95c6cc363e1234fa307)), closes [#4277](https://togithub.com/typeorm/typeorm/issues/4277)
- defaults type cast filtering in Cockroachdb ([#8144](https://togithub.com/typeorm/typeorm/issues/8144)) ([28c183e](https://togithub.com/typeorm/typeorm/commit/28c183e9df562e2eb1e3c93afbd1d4687b1b0846)), closes [#7110](https://togithub.com/typeorm/typeorm/issues/7110) [#7110](https://togithub.com/typeorm/typeorm/issues/7110)
- do not generate migration for unchanged enum column ([#8161](https://togithub.com/typeorm/typeorm/issues/8161)) ([#8164](https://togithub.com/typeorm/typeorm/issues/8164)) ([4638dea](https://togithub.com/typeorm/typeorm/commit/4638dea55d0e9239a62fb3143cd96988bf07bc68))
- NativescriptQueryRunner's query method fails when targeting es2017 ([#8182](https://togithub.com/typeorm/typeorm/issues/8182)) ([8615733](https://togithub.com/typeorm/typeorm/commit/861573377bb33b73232399c21b1b3a5c07b58036))
- OneToManySubjectBuilder bug with multiple primary keys ([#8221](https://togithub.com/typeorm/typeorm/issues/8221)) ([6558295](https://togithub.com/typeorm/typeorm/commit/655829592ee10aaa5d28a96691ada0d5510899ea))
- ordering by joined columns for PostgreSQL ([#3736](https://togithub.com/typeorm/typeorm/issues/3736)) ([#8118](https://togithub.com/typeorm/typeorm/issues/8118)) ([1649882](https://togithub.com/typeorm/typeorm/commit/1649882d335587ac78d2203db3a7ab492a942374))
- support DeleteResult in SQLiteDriver ([#8237](https://togithub.com/typeorm/typeorm/issues/8237)) ([b678807](https://togithub.com/typeorm/typeorm/commit/b6788072c20b5f235df9272625c3d1d7522d27e0))
##### Features
- add `typeorm` command wrapper to package.json in project template ([#8081](https://togithub.com/typeorm/typeorm/issues/8081)) ([19d4a91](https://togithub.com/typeorm/typeorm/commit/19d4a914a5da2c28f1eb4ed1c28a52db7dc809d0))
- add dependency configuraiton for views [#8240](https://togithub.com/typeorm/typeorm/issues/8240) ([#8261](https://togithub.com/typeorm/typeorm/issues/8261)) ([2c861af](https://togithub.com/typeorm/typeorm/commit/2c861afaef839f33b5cf1cc2b3bcf8b6e4a0be4f))
- add relation options to all tree queries ([#8080](https://togithub.com/typeorm/typeorm/issues/8080)) ([e4d4636](https://togithub.com/typeorm/typeorm/commit/e4d46363917db57a9107048b973b6a12be8d61fd)), closes [#8076](https://togithub.com/typeorm/typeorm/issues/8076)
- add the ability to pass the driver into all database types ([#8259](https://togithub.com/typeorm/typeorm/issues/8259)) ([2133ffe](https://togithub.com/typeorm/typeorm/commit/2133ffea9c678841bf3537838777d9a5fec3a00e))
- more informative logging in case of migration failure ([#8307](https://togithub.com/typeorm/typeorm/issues/8307)) ([dc6f1c9](https://togithub.com/typeorm/typeorm/commit/dc6f1c91be29e88466614eb8b8d21a92659cfd0b))
- support using custom index with SelectQueryBuilder in MySQL ([#7755](https://togithub.com/typeorm/typeorm/issues/7755)) ([f79ae58](https://togithub.com/typeorm/typeorm/commit/f79ae589cd1a658fea553cb57abc2a41a46523f8))
##### Reverts
- Revert "fix: STI types on children in joins ([#3160](https://togithub.com/typeorm/typeorm/issues/3160))" ([#8309](https://togithub.com/typeorm/typeorm/issues/8309)) ([0adad88](https://togithub.com/typeorm/typeorm/commit/0adad8810e15b8d00259a2635e1c50e85598e1ed)), closes [#3160](https://togithub.com/typeorm/typeorm/issues/3160) [#8309](https://togithub.com/typeorm/typeorm/issues/8309)
### [`v0.2.38`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0238-httpsgithubcomtypeormtypeormcompare02370238-2021-10-02)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.37...0.2.38)
##### Bug Fixes
- prevent using absolute table path in migrations unless required ([#8038](https://togithub.com/typeorm/typeorm/issues/8038)) ([e9366b3](https://togithub.com/typeorm/typeorm/commit/e9366b33ddff296de1254019589b85e40aa53e12))
- snakecase conversion for strings with numbers ([#8111](https://togithub.com/typeorm/typeorm/issues/8111)) ([749511d](https://togithub.com/typeorm/typeorm/commit/749511d981f6b9a1a08113b23e8779a91cda78f8))
- use full path for table lookups ([#8097](https://togithub.com/typeorm/typeorm/issues/8097)) ([22676a0](https://togithub.com/typeorm/typeorm/commit/22676a04c30b3b49a61003320dfad3ecad3791e8))
##### Features
- support QueryRunner.stream with Oracle ([#8086](https://togithub.com/typeorm/typeorm/issues/8086)) ([b858f84](https://togithub.com/typeorm/typeorm/commit/b858f84e6fb15f801f2564088428d250d1c59e18))
### [`v0.2.37`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0237-httpsgithubcomtypeormtypeormcompare02360237-2021-08-13)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.36...0.2.37)
##### Bug Fixes
- allow periods in parameter identifiers ([#8022](https://togithub.com/typeorm/typeorm/issues/8022)) ([4201938](https://togithub.com/typeorm/typeorm/commit/420193892ffe857c532130c0c7b18dcc4c8d38e2))
- ConnectionManager `connections` property should include list of `Connection`s ([#8004](https://togithub.com/typeorm/typeorm/issues/8004)) ([2344db6](https://togithub.com/typeorm/typeorm/commit/2344db60c4314da31885f5686e94bb6dcb203a96))
- entity value for date columns that are related ([#8027](https://togithub.com/typeorm/typeorm/issues/8027)) ([5a3767f](https://togithub.com/typeorm/typeorm/commit/5a3767f58f6ef355b01cf6e92342401a051a369c))
- handle brackets when only one condition is passed ([#8048](https://togithub.com/typeorm/typeorm/issues/8048)) ([ab39066](https://togithub.com/typeorm/typeorm/commit/ab39066f182d357fcc999cd976510c0e2a61d6de))
- handle enums with multiple apostrophes in MySQL ([#8013](https://togithub.com/typeorm/typeorm/issues/8013)) ([37c40a6](https://togithub.com/typeorm/typeorm/commit/37c40a610caecfc3b27b48a87b0e98d715f23395)), closes [#8011](https://togithub.com/typeorm/typeorm/issues/8011)
- include all drivers in driverfactory error message ([#8061](https://togithub.com/typeorm/typeorm/issues/8061)) ([fbd1ef7](https://togithub.com/typeorm/typeorm/commit/fbd1ef74e84b59ef0b8d99e311f0aced902190e6))
- resolve not returning soft deleted relations with withDeleted find option ([#8017](https://togithub.com/typeorm/typeorm/issues/8017)) ([65cbcc7](https://togithub.com/typeorm/typeorm/commit/65cbcc79bceac4cf8d15dec8c558dcbc9a037220))
- SAP HANA inserts used incorrect value for returning query ([#8072](https://togithub.com/typeorm/typeorm/issues/8072)) ([36398db](https://togithub.com/typeorm/typeorm/commit/36398dbe467274a9ac08a013ed4daaf307ee2de2))
- some drivers set the wrong database name when defined from url ([#8058](https://togithub.com/typeorm/typeorm/issues/8058)) ([a3a3284](https://togithub.com/typeorm/typeorm/commit/a3a32849c04a83adbf775fcf07843a934551dbfb))
- throw error when not connected in drivers ([#7995](https://togithub.com/typeorm/typeorm/issues/7995)) ([cd71f62](https://togithub.com/typeorm/typeorm/commit/cd71f62cb8125d1bbd92b341aa2eea1de0ac3537))
##### Features
- add relations option to tree queries ([#7981](https://togithub.com/typeorm/typeorm/issues/7981)) ([ca26297](https://togithub.com/typeorm/typeorm/commit/ca26297484542498b8f622f540ca354360d53ed0)), closes [#7974](https://togithub.com/typeorm/typeorm/issues/7974) [#4564](https://togithub.com/typeorm/typeorm/issues/4564)
- add serviceName option for oracle connections ([#8021](https://togithub.com/typeorm/typeorm/issues/8021)) ([37bd012](https://togithub.com/typeorm/typeorm/commit/37bd0124dc81c957b2a036436594ae8c4606eb6c))
- add support to string array on dropColumns ([#7654](https://togithub.com/typeorm/typeorm/issues/7654)) ([91d5b2f](https://togithub.com/typeorm/typeorm/commit/91d5b2fc374c2f7b1545d40ee76577272de21436))
- support Oracle Implicit Results ([#8050](https://togithub.com/typeorm/typeorm/issues/8050)) ([fe78bee](https://togithub.com/typeorm/typeorm/commit/fe78bee3725efef47d5be6f924b9caf13f3299a7))
### [`v0.2.36`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0236-httpsgithubcomtypeormtypeormcompare02350236-2021-07-31)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.35...0.2.36)
##### Bug Fixes
- add deprecated `WhereExpression` alias for `WhereExpressionBuilder` ([#7980](https://togithub.com/typeorm/typeorm/issues/7980)) ([76e7ed9](https://togithub.com/typeorm/typeorm/commit/76e7ed943779b940212c4e453d97028b5ffed7d0))
- always generate migrations with template string literals ([#7971](https://togithub.com/typeorm/typeorm/issues/7971)) ([e9c2af6](https://togithub.com/typeorm/typeorm/commit/e9c2af610a1c9a632605b71d67b97e048be2e29e))
- use js rather than ts in all `browser` package manifests ([#7982](https://togithub.com/typeorm/typeorm/issues/7982)) ([0d90bcd](https://togithub.com/typeorm/typeorm/commit/0d90bcdc8c77f2080aa200fe9f4f962b7b01c9ee))
- use nvarchar/ntext during transit for SQLServer queries ([#7933](https://togithub.com/typeorm/typeorm/issues/7933)) ([62d7976](https://togithub.com/typeorm/typeorm/commit/62d79762dbfe58219a5673ba4d404fe9f2e40436))
##### Features
- add postgres connection option `applicationName` ([#7989](https://togithub.com/typeorm/typeorm/issues/7989)) ([d365acc](https://togithub.com/typeorm/typeorm/commit/d365acca68069d0bd9acea5b45a73d7f4c1f4d8f))
### [`v0.2.35`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0235-httpsgithubcomtypeormtypeormcompare02340235-2021-07-28)
[Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.34...0.2.35)
##### Bug Fixes
- `entity` to be `Partial` | `undefined` in `UpdateEvent` ([#7783](https://togithub.com/typeorm/typeorm/issues/7783)) ([f033045](https://togithub.com/typeorm/typeorm/commit/f033045dd6d1dac4f6f7e528997a2c5f8892d763))
- actually return a working ReadStream from SQL Server query runner ([#7893](https://togithub.com/typeorm/typeorm/issues/7893)) ([e80985f](https://togithub.com/typeorm/typeorm/commit/e80985fabbafcb4f5409d72840c3902e1619b8a6))
- added version check before dropping materialized views to keep backward compatibility ([#7716](https://togithub.com/typeorm/typeorm/issues/7716)) ([29f1f86](https://togithub.com/typeorm/typeorm/commit/29f1f86ae2a2dafd70fd958b1980b9f059f42f7a))
- allow for string id in mongo.findByIds call ([#7838](https://togithub.com/typeorm/typeorm/issues/7838)) ([4b45ae1](https://togithub.com/typeorm/typeorm/commit/4b45ae1e8174cf438f9fca92c635957513bff8f8))
- better support of relation-based properties in where clauses ([#7805](https://togithub.com/typeorm/typeorm/issues/7805)) ([3221c50](https://togithub.com/typeorm/typeorm/commit/3221c50d878505b1b8435b07451ec94cd8d04fce))
- Buffer in primary columns causes bugs with relations ([#7952](https://togithub.com/typeorm/typeorm/issues/7952)) ([37e08a7](https://togithub.com/typeorm/typeorm/commit/37e08a7848a92cd4f98fec8f33f120cee739352f)), closes [#4060](https://togithub.com/typeorm/typeorm/issues/4060)
- capacitor does not correctly set journal mode ([#7873](https://togithub.com/typeorm/typeorm/issues/7873)) ([5f20eb7](https://togithub.com/typeorm/typeorm/commit/5f20eb791a3c51410d6759548ec11c9a919659ff))
- Capacitor driver PRAGMA requests failing on Android ([#7728](https://togithub.com/typeorm/typeorm/issues/7728)) ([9620a26](https://togithub.com/typeorm/typeorm/commit/9620a26c4eeb34baddce3a841ffd686d82cd87af))
- condition is optional in SelectQueryBuilder joins ([#7888](https://togithub.com/typeorm/typeorm/issues/7888)) ([2deaa0e](https://togithub.com/typeorm/typeorm/commit/2deaa0e948d7b797c0e4d3ccbc3c9c2f0f253caf))
- correctly handle mongo replica set driver option ([#7908](https://togithub.com/typeorm/typeorm/issues/7908)) ([9212df4](https://togithub.com/typeorm/typeorm/commit/9212df45e3899370efdf9ec67f1a6418ce4ac838))
- correctly load yml in ConnectionOptionsYmlReader ([#7743](https://togithub.com/typeorm/typeorm/issues/7743)) ([57f9254](https://togithub.com/typeorm/typeorm/commit/57f9254499ef07500f5e59df20e778ee0f27b9aa))
- craft oracle connectString as a descriptor with SID ([#7878](https://togithub.com/typeorm/typeorm/issues/7878)) ([b05d093](https://togithub.com/typeorm/typeorm/commit/b05d0936ddabae179a42c9c0f67779a6bec3d5b1))
- delete operation in MongoDB impact all matched documents ([#7811](https://togithub.com/typeorm/typeorm/issues/7811)) ([0fbae53](https://togithub.com/typeorm/typeorm/commit/0fbae53bdd83f5da94ac8a468e1506c2852eed02)), closes [#7809](https://togithub.com/typeorm/typeorm/issues/7809)
- Do not add NULL/NOT NULL for stored columns ([#7708](https://togithub.com/typeorm/typeorm/issues/7708)) ([3c33e9f](https://togithub.com/typeorm/typeorm/commit/3c33e9f54541a12b0d0fd37177c6afebf7a5349f)), closes [#7698](https://togithub.com/typeorm/typeorm/issues/7698)
- do OBJECT_ID lookup for column constraint instead of name in mssql ([#7916](https://togithub.com/typeorm/typeorm/issues/7916)) ([fa8c1b0](https://togithub.com/typeorm/typeorm/commit/fa8c1b088a9a6a2a1ffaec1b1a681be99cf2db3c))
- drop pool.autostart from mssql options because it's unused ([#7877](https://togithub.com/typeorm/typeorm/issues/7877)) ([0d21a4d](https://togithub.com/typeorm/typeorm/commit/0d21a4d07ec275a295df6f78b85c4814c027258a))
- drop SAP statement after `prepare` per Hana client docs ([#7748](https://togithub.com/typeorm/typeorm/issues/7748)) ([8ca05b1](https://togithub.com/typeorm/typeorm/commit/8ca05b11db3ba083c7395cca09a4aa98c70e3d8f))
- eager relation respects children relations ([#5685](https://togithub.com/typeorm/typeorm/issues/5685)) ([e7e887a](https://togithub.com/typeorm/typeorm/commit/e7e887a582cce66bd21044472f4a5288894650c9))
- enable returning additional columns with MSSQL ([#7864](https://togithub.com/typeorm/typeorm/issues/7864)) ([e1db48d](https://togithub.com/typeorm/typeorm/commit/e1db48d8391728455744c91ea7976a334300f77d))
- entity object undefined in `afterUpdate` subscriber ([#7724](https://togithub.com/typeorm/typeorm/issues/7724)) ([d25304d](https://togithub.com/typeorm/typeorm/commit/d25304d9e319157c6b8999932fb9144a67bd84cf))
- find operation in MongoDB do not include nullable values from documents ([#7820](https://togithub.com/typeorm/typeorm/issues/7820)) ([98c13cf](https://togithub.com/typeorm/typeorm/commit/98c13cf710de83783bc5b5576a64327b26d26262)), closes [#7760](https://togithub.com/typeorm/typeorm/issues/7760)
- fix table loading when schemas are used ([3a106a3](https://togithub.com/typeorm/typeorm/commit/3a106a3cca223dadca58af1244c6dda79c60b43c))
- foreign keys in SAP were loading from the wrong table ([#7914](https://togithub.com/typeorm/typeorm/issues/7914)) ([4777a79](https://togithub.com/typeorm/typeorm/commit/4777a795210c3a93a4171a17dbdce248e25b21da))
- handle postgres default when tableColumn.default is not string ([#7816](https://togithub.com/typeorm/typeorm/issues/7816)) ([0463855](https://togithub.com/typeorm/typeorm/commit/0463855223100028e62f7cb2e84319770f54449e))
- handle snake case of ABcD which should become a_bc_d ([#7883](https://togithub.com/typeorm/typeorm/issues/7883)) ([eb680f9](https://togithub.com/typeorm/typeorm/commit/eb680f99b74c335556d23016264fcf1ea6ce1d6f))
- improve query for MSSQL to fetch foreign keys and tables ([#7935](https://togithub.com/typeorm/typeorm/issues/7935)) ([f6af01a](https://togithub.com/typeorm/typeorm/commit/f6af01ad1b20ce67dc03448f050de3127227758c))
- make `OracleQueryRunner` createDatabase if-not-exists not fail ([f5a80ef](https://togithub.com/typeorm/typeorm/commit/f5a80ef3df82120fee8f68e02f320dacbc856607))
- only pass `data` from SaveOptions during that query ([#7886](https://togithub.com/typeorm/typeorm/issues/7886)) ([1de2e13](https://togithub.com/typeorm/typeorm/commit/1de2e13cfe442af99c2cf017f48127e1de3a08d9))
- oracle cannot support DB in table identifiers ([#7954](https://togithub.com/typeorm/typeorm/issues/7954)) ([8c60d91](https://togithub.com/typeorm/typeorm/commit/8c60d917ef5fbfdc11b7c3ad8e2901eba3f9fa4b))
- pass table to namingstrategy when we can instead of table name ([#7925](https://togithub.com/typeorm/typeorm/issues/7925)) ([140002d](https://togithub.com/typeorm/typeorm/commit/140002d1ebc4837071dab83a7bb164a02a7a2732))
- prevent modification of the FindOptions.relations ([#7887](https://togithub.com/typeorm/typeorm/issues/7887)) ([a2fcad6](https://togithub.com/typeorm/typeorm/commit/a2fcad6ef963c3e444765d6a7b4fa1e0e89a72e6))
- prevent reuse of broken connections in postgres pool ([#7792](https://togithub.com/typeorm/typeorm/issues/7792)) ([5cf368a](https://togithub.com/typeorm/typeorm/commit/5cf368a23fa78b9e97dd12b54616f17b8431ffee))
- prevent transactions in the Cordova driver ([#7771](https://togithub.com/typeorm/typeorm/issues/7771)) ([fc4133c](https://togithub.com/typeorm/typeorm/commit/fc4133cf621874c616bf7643c79112b9f68a1e09))
- properly escape oracle table paths ([#7917](https://togithub.com/typeorm/typeorm/issues/7917)) ([7e8687c](https://togithub.com/typeorm/typeorm/commit/7e8687c45283cdb2caffa53ed5ebab527797c3e8))
- regression when making `join` conditions `undefined`-able ([#7892](https://togithub.com/typeorm/typeorm/issues/7892)) ([b0c1cc6](https://togithub.com/typeorm/typeorm/commit/b0c1cc6d6820e93bc7b986d4f18db4020195e170))
- restored `buildColumnAlias` for backward compatibility ([#7706](https://togithub.com/typeorm/typeorm/issues/7706)) ([36ceefa](https://togithub.com/typeorm/typeorm/commit/36ceefa710c0994e054c8e267a1fb1bdf4b25c39))
- return correct DeleteResult and UpdateResult for mongo ([#7884](https://togithub.com/typeorm/typeorm/issues/7884)) ([7a646a2](https://togithub.com/typeorm/typeorm/commit/7a646a212815e6b9c2dda752442075624f9f552d))
- support fully qualified schema in createSchema ([#7934](https://togithub.com/typeorm/typeorm/issues/7934)) ([94edd12](https://togithub.com/typeorm/typeorm/commit/94edd12ca450d4dbcd2e4902e1009fcd27136490))
- support table names between schemas in oracle ([#7951](https://togithub.com/typeorm/typeorm/issues/7951)) ([aa45b93](https://togithub.com/typeorm/typeorm/commit/aa45b935ff33915a86199307c86aabf904d67e28))
- typing so SelectQueryBuilder.getRawOne may return undefined ([#7863](https://togithub.com/typeorm/typeorm/issues/7863)) ([36e5a0c](https://togithub.com/typeorm/typeorm/commit/36e5a0cf09a25dfe98ffa130f35005a8eacc4155)), closes [#7449](https://togithub.com/typeorm/typeorm/issues/7449)
- typo prevented us from pulling the schema correctly in some cases ([c7f2db8](https://togithub.com/typeorm/typeorm/commit/c7f2db8d6999b990308787681a2767e41ad2bdd6))
- update operation in MongoDB impact all matched documents ([#7803](https://togithub.com/typeorm/typeorm/issues/7803)) ([052014c](https://togithub.com/typeorm/typeorm/commit/052014cdba844b1a7867f46606045a494cffc907)), closes [#7788](https://togithub.com/typeorm/typeorm/issues/7788)
- use correct query for cross-database mssql identity check ([#7911](https://togithub.com/typeorm/typeorm/issues/7911)) ([7869fb1](https://togithub.com/typeorm/typeorm/commit/7869fb143c2b3ec019507a79e80eb2e29c270338))
- use fully qualified and escaped table names for oracle ([#7857](https://togithub.com/typeorm/typeorm/issues/7857)) ([2b90725](https://togithub.com/typeorm/typeorm/commit/2b90725a080c7ea9140464a68c8c8c9475fd73f9)), closes [#7779](https://togithub.com/typeorm/typeorm/issues/7779)
- use ObjectLiteral in UpdateEvent rather than `Entity` ([#7910](https://togithub.com/typeorm/typeorm/issues/7910)) ([78fbc14](https://togithub.com/typeorm/typeorm/commit/78fbc14b3ee915ce035cb1546c92142eab6a899e))
- use only table name in constraint naming strategy ([5dc777f](https://togithub.com/typeorm/typeorm/commit/5dc777f17ec238c3f3303aa9379fe855727220b1))
##### Features
- add `retryWrites` to allowed mongo `extra` options ([#7869](https://togithub.com/typeorm/typeorm/issues/7869)) ([dcdaaca](https://togithub.com/typeorm/typeorm/commit/dcdaacacaf122c7579d31a700e93c5357a9e0a16))
- add capacitor driver options for encryption & version ([#7868](https://togithub.com/typeorm/typeorm/issues/7868)) ([a2bd94b](https://togithub.com/typeorm/typeorm/commit/a2bd94b146738a2aa637f52011c1fd5e92ed38e1))
- add connection option `entitySkipConstructor` ([f43d561](https://togithub.com/typeorm/typeorm/commit/f43d56110fd41c23d80e32021adf4ade7648ce97))
- add ObjectLiteral typing to andWhere / orWhere ([#7786](https://togithub.com/typeorm/typeorm/issues/7786)) ([525381d](https://togithub.com/typeorm/typeorm/commit/525381d91e15d1d9b9dd7bd36beaac35646ee3b0))
- add parseTableName to Driver interface ([#7956](https://togithub.com/typeorm/typeorm/issues/7956)) ([cffbf43](https://togithub.com/typeorm/typeorm/commit/cffbf43b291e59a45c5b8e3685a1d1153dfeaeb1))
- add path, database, and schema to Table ([#7913](https://togithub.com/typeorm/typeorm/issues/7913)) ([444e38b](https://togithub.com/typeorm/typeorm/commit/444e38bffd7f3ff962282d01bf980a554a94b3fa))
- add property for database and schema in views ([#7953](https://togithub.com/typeorm/typeorm/issues/7953)) ([4c5bbd9](https://togithub.com/typeorm/typeorm/commit/4c5bbd9e1c92219712efaff061d6501c473193dd))
- add referenced database & schema to TableForeignKey ([fff6b11](https://togithub.com/typeorm/typeorm/commit/fff6b11cd3c369f9f95c99decba84213847e76e3))
- add writeConcern option as a possible `extras` for mongodb ([#7801](https://togithub.com/typeorm/typeorm/issues/7801)) ([90894c7](https://togithub.com/typeorm/typeorm/commit/90894c7fd39c5237ddb26690082ca4c2443b2fd4))
- consistent parsing and escaping of table names in QueryRunners ([bd9e767](https://togithub.com/typeorm/typeorm/commit/bd9e767ffaafe9381630787fa860d0904b8d3e49))
- implement OracleQueryRunner.hasDatabase ([128b982](https://togithub.com/typeorm/typeorm/commit/128b9825f2b9fd81c4ee5ba36e554ef86eb64865))
- make parameter to getTables optional ([#7901](https://togithub.com/typeorm/typeorm/issues/7901)) ([ba86602](https://togithub.com/typeorm/typeorm/commit/ba866026ec7d0ce44f68f9b585bc094c82e32dcd))
- make postgres extensions install optional ([#7725](https://togithub.com/typeorm/typeorm/issues/7725)) ([92b96a5](https://togithub.com/typeorm/typeorm/commit/92b96a550512bb218e1c6691e2f5908007d0b6e6)), closes [#7662](https://togithub.com/typeorm/typeorm/issues/7662)
- publicly export `Transaction*Event` types ([#7949](https://togithub.com/typeorm/typeorm/issues/7949)) ([2436a66](https://togithub.com/typeorm/typeorm/commit/2436a66b499c81e1d2394b19f3b158258f31d899)), closes [/github.com/typeorm/typeorm/blob/master/src/subscriber/EntitySubscriberInterface.ts#L12](https://togithub.com//github.com/typeorm/typeorm/blob/master/src/subscriber/EntitySubscriberInterface.ts/issues/L12)
- set `enableArithAbort` for SQLServerDriver ([#7894](https://togithub.com/typeorm/typeorm/issues/7894)) ([1f64da2](https://togithub.com/typeorm/typeorm/commit/1f64da2c49b21b678a0f2faf0805dbeb763b0f4a))
- support absolute path in migration:generate ([#7720](https://togithub.com/typeorm/typeorm/issues/7720)) ([b690c27](https://togithub.com/typeorm/typeorm/commit/b690c270cd2e9886329e520cab5ee31eaeae77a4))
- use char(36) for uuid representation in mysql ([#7853](https://togithub.com/typeorm/typeorm/issues/7853)) ([063aafa](https://togithub.com/typeorm/typeorm/commit/063aafa34408dd9b1ed3802bb43be6f772523277))
- use column length from driver when creating columns ([#7858](https://togithub.com/typeorm/typeorm/issues/7858)) ([b107ad9](https://togithub.com/typeorm/typeorm/commit/b107ad95164627b6e959b4e476eb82f3dded972c))
Configuration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
[ ] If you want to rebase/retry this PR, click this checkbox.
This PR contains the following updates:
0.2.34
->0.2.45
Release Notes
typeorm/typeorm
### [`v0.2.45`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0245-httpsgithubcomtypeormtypeormcompare02440245-2022-03-04) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.44...0.2.45) ##### Bug Fixes - allow clearing database inside a transaction ([#8712](https://togithub.com/typeorm/typeorm/issues/8712)) ([f3cfdd2](https://togithub.com/typeorm/typeorm/commit/f3cfdd264105ba8cf1c92832b4b95e5a3ca0ed09)), closes [#8527](https://togithub.com/typeorm/typeorm/issues/8527) - discard duplicated columns on update ([#8724](https://togithub.com/typeorm/typeorm/issues/8724)) ([0fc093d](https://togithub.com/typeorm/typeorm/commit/0fc093d168b54a0fd99bb411a730aad9be1858ac)), closes [#8723](https://togithub.com/typeorm/typeorm/issues/8723) - fix entityManager.getId for custom join table ([#8676](https://togithub.com/typeorm/typeorm/issues/8676)) ([33b2bd7](https://togithub.com/typeorm/typeorm/commit/33b2bd7acc55d6eb30bfe0681748d6b6abaff0b5)), closes [#7736](https://togithub.com/typeorm/typeorm/issues/7736) - force web bundlers to ignore index.mjs and use the browser ESM version directly ([#8710](https://togithub.com/typeorm/typeorm/issues/8710)) ([411fa54](https://togithub.com/typeorm/typeorm/commit/411fa54368c8940e94b1cbf7ab64b8d5377f9406)), closes [#8709](https://togithub.com/typeorm/typeorm/issues/8709) ##### Features - add nested transaction ([#8541](https://togithub.com/typeorm/typeorm/issues/8541)) ([6523526](https://togithub.com/typeorm/typeorm/commit/6523526003bab74a0df8f7d578790c1728b26057)), closes [#1505](https://togithub.com/typeorm/typeorm/issues/1505) - add transformer to ViewColumnOptions ([#8717](https://togithub.com/typeorm/typeorm/issues/8717)) ([96ac8f7](https://togithub.com/typeorm/typeorm/commit/96ac8f7eece06ae0a8b52ae7da740c92c0c0d4b9)) ### [`v0.2.44`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0244-httpsgithubcomtypeormtypeormcompare02430244-2022-02-23) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.43...0.2.44) ##### Bug Fixes - alter relation loader to use transforms when present ([#8691](https://togithub.com/typeorm/typeorm/issues/8691)) ([2c2fb29](https://togithub.com/typeorm/typeorm/commit/2c2fb29a67bfd0ca7dd9133a2f85f5b4db5fb195)), closes [#8690](https://togithub.com/typeorm/typeorm/issues/8690) - cannot read properties of undefined (reading 'joinEagerRelations') ([136015b](https://togithub.com/typeorm/typeorm/commit/136015b04ee72b0ca2439fbff53b1467c12c24b6)) - expo driver doesn't work properly because of new beforeMigration() afterMigration() callbacks ([#8683](https://togithub.com/typeorm/typeorm/issues/8683)) ([5a71803](https://togithub.com/typeorm/typeorm/commit/5a7180378e34ab58ad40c504ebc5195e2413c5f4)) - ng webpack default import ([#8688](https://togithub.com/typeorm/typeorm/issues/8688)) ([2d3374b](https://togithub.com/typeorm/typeorm/commit/2d3374b3b4cb8163764c035bd687b2c81787f338)), closes [#8674](https://togithub.com/typeorm/typeorm/issues/8674) - support imports of absolute paths of ESM files on Windows ([#8669](https://togithub.com/typeorm/typeorm/issues/8669)) ([12cbfcd](https://togithub.com/typeorm/typeorm/commit/12cbfcde7bc4f56069ed3298064bb91ad0816bf0)), closes [#8651](https://togithub.com/typeorm/typeorm/issues/8651) ##### Features - add option to upsert to skip update if the row already exists and no values would be changed ([#8679](https://togithub.com/typeorm/typeorm/issues/8679)) ([8744395](https://togithub.com/typeorm/typeorm/commit/87443954b59768ab77fb15097ea9d88822b4a733)) - allow `{delete,insert}().returning()` on MariaDB ([#8673](https://togithub.com/typeorm/typeorm/issues/8673)) ([7facbab](https://togithub.com/typeorm/typeorm/commit/7facbabd2663098156a53983ea38433ed39082d2)), closes [#7235](https://togithub.com/typeorm/typeorm/issues/7235) [#7235](https://togithub.com/typeorm/typeorm/issues/7235) - Implement deferrable foreign keys for SAP HANA ([#6104](https://togithub.com/typeorm/typeorm/issues/6104)) ([1f54c70](https://togithub.com/typeorm/typeorm/commit/1f54c70b76de34d4420904b72137df746ea9aaed)) ### [`v0.2.43`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0243-httpsgithubcomtypeormtypeormcompare02420243-2022-02-17) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.42...0.2.43) ##### Bug Fixes - support `require` to internal files without explicitly writing `.js` in the path ([#8660](https://togithub.com/typeorm/typeorm/issues/8660)) ([96aed8a](https://togithub.com/typeorm/typeorm/commit/96aed8aae06df0ae555aa51ed9f1a5ffec141e61)), closes [#8656](https://togithub.com/typeorm/typeorm/issues/8656) ##### Features - embedded entities with entity schema ([#8626](https://togithub.com/typeorm/typeorm/issues/8626)) ([7dbe956](https://togithub.com/typeorm/typeorm/commit/7dbe956c56da3a430ae6f0e99730e9449deae889)), closes [#3632](https://togithub.com/typeorm/typeorm/issues/3632) ##### Reverts - Revert "feat: soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436))" ([#8654](https://togithub.com/typeorm/typeorm/issues/8654)) ([6b0b15b](https://togithub.com/typeorm/typeorm/commit/6b0b15b0e68584ed7cd81a658d8606cfdb96817c)), closes [#8436](https://togithub.com/typeorm/typeorm/issues/8436) [#8654](https://togithub.com/typeorm/typeorm/issues/8654) ### [`v0.2.42`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0242-httpsgithubcomtypeormtypeormcompare02410242-2022-02-16) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.41...0.2.42) ##### Bug Fixes - proper column comment mapping from database to metadata in aurora-data-api ([baa5880](https://togithub.com/typeorm/typeorm/commit/baa5880001064333eb4eb01765b1d79e17cf1fb5)) - add referencedSchema to PostgresQueryRunner ([#8566](https://togithub.com/typeorm/typeorm/issues/8566)) ([c490319](https://togithub.com/typeorm/typeorm/commit/c49031929aca8f3b932c6593b75447256085bfef)) - adding/removing [@Generated](https://togithub.com/Generated)() will now generate a migration to add/remove the DEFAULT value ([#8274](https://togithub.com/typeorm/typeorm/issues/8274)) ([4208393](https://togithub.com/typeorm/typeorm/commit/42083936e2b65f0d1bd8e23d12689a7f49e2da2f)), closes [#5898](https://togithub.com/typeorm/typeorm/issues/5898) - adds entity-schema support for createForeignKeyConstraints ([#8606](https://togithub.com/typeorm/typeorm/issues/8606)) ([f224f24](https://togithub.com/typeorm/typeorm/commit/f224f24e5247d3c42385bfc03c89f518aa932310)), closes [#8489](https://togithub.com/typeorm/typeorm/issues/8489) - allow special keyword as column name for simple-enum type on sqlite ([#8645](https://togithub.com/typeorm/typeorm/issues/8645)) ([93bf96e](https://togithub.com/typeorm/typeorm/commit/93bf96ea635823c7933ea8ef7326be62ccdd6ea7)) - correctly handle multiple-row insert for SAP HANA driver ([#7957](https://togithub.com/typeorm/typeorm/issues/7957)) ([8f2ae71](https://togithub.com/typeorm/typeorm/commit/8f2ae71201e7738fe3c1efd5bbc4584dfe62dcc0)) - disable SQLite FK checks in synchronize / migrations ([#7922](https://togithub.com/typeorm/typeorm/issues/7922)) ([f24822e](https://togithub.com/typeorm/typeorm/commit/f24822ef9cb3051fbe9f3fd5d9e669788852c5a5)) - find descendants of a non-existing tree parent ([#8557](https://togithub.com/typeorm/typeorm/issues/8557)) ([cbb61eb](https://togithub.com/typeorm/typeorm/commit/cbb61eb08139204479110c88d7d1849a24080d11)), closes [#8556](https://togithub.com/typeorm/typeorm/issues/8556) - For MS SQL Server use lowercase "sys"."columns" reference. ([#8400](https://togithub.com/typeorm/typeorm/issues/8400)) ([#8401](https://togithub.com/typeorm/typeorm/issues/8401)) ([e8a0f92](https://togithub.com/typeorm/typeorm/commit/e8a0f921b4baa7aa7e55ac1fd34c449dfa1e3229)) - improve DeepPartial type ([#8187](https://togithub.com/typeorm/typeorm/issues/8187)) ([b93416d](https://togithub.com/typeorm/typeorm/commit/b93416d7bc25006b34a90c14c497cc7e6e57e28c)) - Lock peer dependencies versions ([#8597](https://togithub.com/typeorm/typeorm/issues/8597)) ([600bd4e](https://togithub.com/typeorm/typeorm/commit/600bd4e5da74b012409d1fdf411a0a0b5265466b)) - make EntityMetadataValidator comply with entitySkipConstructor, cover with test ([#8445](https://togithub.com/typeorm/typeorm/issues/8445)) ([3d6c5da](https://togithub.com/typeorm/typeorm/commit/3d6c5dae76ad0e0640650058ae58fe0addda2ae6)), closes [#8444](https://togithub.com/typeorm/typeorm/issues/8444) - materialized path being computed as "undefined1." ([#8526](https://togithub.com/typeorm/typeorm/issues/8526)) ([09f54e0](https://togithub.com/typeorm/typeorm/commit/09f54e0273be4dc836824a38e9c78b50ad21bba6)) - MongoConnectionOptions sslCA type mismatch ([#8628](https://togithub.com/typeorm/typeorm/issues/8628)) ([02400da](https://togithub.com/typeorm/typeorm/commit/02400dab662aceca9a722c4aa0dd74a9fa2cb90d)) - mongodb repository.find filters soft deleted rows ([#8581](https://togithub.com/typeorm/typeorm/issues/8581)) ([f7c1f7d](https://togithub.com/typeorm/typeorm/commit/f7c1f7d7c0481f4ada506e5b811a3219519eadf9)), closes [#7113](https://togithub.com/typeorm/typeorm/issues/7113) - mongodb@4 compatibility support ([#8412](https://togithub.com/typeorm/typeorm/issues/8412)) ([531013b](https://togithub.com/typeorm/typeorm/commit/531013b2f8dfb8d04b0bfb844dc83a5ba6404569)) - must invoke key pragma before any other interaction if SEE setted ([#8478](https://togithub.com/typeorm/typeorm/issues/8478)) ([546b3ed](https://togithub.com/typeorm/typeorm/commit/546b3ed8886c44fbe3d9e167d1904cb9e5961df7)), closes [#8475](https://togithub.com/typeorm/typeorm/issues/8475) - nested eager relations in a lazy-loaded entity are not loaded ([#8564](https://togithub.com/typeorm/typeorm/issues/8564)) ([1cfd7b9](https://togithub.com/typeorm/typeorm/commit/1cfd7b98ba27032dd0e9429a245c40cea47900f7)) - QueryFailedError when tree entity with JoinColumn ([#8443](https://togithub.com/typeorm/typeorm/issues/8443)) ([#8447](https://togithub.com/typeorm/typeorm/issues/8447)) ([a11c50d](https://togithub.com/typeorm/typeorm/commit/a11c50d5519bda1410ab9ccf67bfcb12ef109c61)) - relation id and afterAll hook performance fixes ([#8169](https://togithub.com/typeorm/typeorm/issues/8169)) ([31f0b55](https://togithub.com/typeorm/typeorm/commit/31f0b5535aa0cc49ff23610b1924c03432f5461f)) - replaced custom uuid generator with `uuid` library ([#8642](https://togithub.com/typeorm/typeorm/issues/8642)) ([8898a71](https://togithub.com/typeorm/typeorm/commit/8898a7175f481f1c171acefef61dc089bc3f8a8e)) - single table inheritance returns the same discriminator value error for unrelated tables where their parents extend from the same entity ([#8525](https://togithub.com/typeorm/typeorm/issues/8525)) ([6523fcc](https://togithub.com/typeorm/typeorm/commit/6523fccda1147dc697afbba57792e5cb4165fbf2)), closes [#8522](https://togithub.com/typeorm/typeorm/issues/8522) - updating with only `update: false` columns shouldn't trigger [@UpdateDateColumn](https://togithub.com/UpdateDateColumn) column updation ([2834729](https://togithub.com/typeorm/typeorm/commit/2834729e80577bd30f09c2c0e4c949cde173bba3)), closes [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) [#8394](https://togithub.com/typeorm/typeorm/issues/8394) - upsert should find unique index created by one-to-one relation ([#8618](https://togithub.com/typeorm/typeorm/issues/8618)) ([c8c00ba](https://togithub.com/typeorm/typeorm/commit/c8c00baf9351973be5780687418303dd87de2077)) ##### Features - add comment param to FindOptions ([#8545](https://togithub.com/typeorm/typeorm/issues/8545)) ([ece0da0](https://togithub.com/typeorm/typeorm/commit/ece0da027dfce4357764dda4b810598ad64af9d9)) - add custom timestamp option in migration creation ([#8501](https://togithub.com/typeorm/typeorm/issues/8501)) ([4a7f242](https://togithub.com/typeorm/typeorm/commit/4a7f2420f1b498465b2a5913b7d848b3eaafb113)), closes [#8500](https://togithub.com/typeorm/typeorm/issues/8500) [#8500](https://togithub.com/typeorm/typeorm/issues/8500) - add support for node-redis v4.0.0 and newer ([#8425](https://togithub.com/typeorm/typeorm/issues/8425)) ([0626ed1](https://togithub.com/typeorm/typeorm/commit/0626ed1f0bd75fb8e72a462593f33813d85faee8)) - add support for Postgres 10+ GENERATED ALWAYS AS IDENTITY ([#8371](https://togithub.com/typeorm/typeorm/issues/8371)) ([a0f09de](https://togithub.com/typeorm/typeorm/commit/a0f09de8400ac7c94df33f8213ef0eec79b9239d)), closes [#8370](https://togithub.com/typeorm/typeorm/issues/8370) - add WITH (lock) clause for MSSQL select with join queries ([#8507](https://togithub.com/typeorm/typeorm/issues/8507)) ([3284808](https://togithub.com/typeorm/typeorm/commit/3284808b63552d81456752187c0d130db76007ed)), closes [#4764](https://togithub.com/typeorm/typeorm/issues/4764) - adds entity-schema support for withoutRowid ([#8432](https://togithub.com/typeorm/typeorm/issues/8432)) ([bd22dc3](https://togithub.com/typeorm/typeorm/commit/bd22dc3b8175ef82967b8265a2388ce16cc08623)), closes [#8429](https://togithub.com/typeorm/typeorm/issues/8429) - allow soft-deletion of orphaned relation rows using orphanedRow… ([#8414](https://togithub.com/typeorm/typeorm/issues/8414)) ([cefddd9](https://togithub.com/typeorm/typeorm/commit/cefddd95c550191d6a18cb53c8ea4995d0c219ca)) - custom name for typeorm_metadata table ([#8528](https://togithub.com/typeorm/typeorm/issues/8528)) ([f8154eb](https://togithub.com/typeorm/typeorm/commit/f8154eb4c5089a1a0d2c2073f0ea5d64b3252e08)), closes [#7266](https://togithub.com/typeorm/typeorm/issues/7266) - deferrable option for Unique constraints (Postgres) ([#8356](https://togithub.com/typeorm/typeorm/issues/8356)) ([e52b26c](https://togithub.com/typeorm/typeorm/commit/e52b26c910047d22aa3ea003b62d11c2bf352249)) - ESM support ([#8536](https://togithub.com/typeorm/typeorm/issues/8536)) ([3a694dd](https://togithub.com/typeorm/typeorm/commit/3a694dd3e99699e7284709c53967a5dfcb1e1806)), closes [#6974](https://togithub.com/typeorm/typeorm/issues/6974) [#6941](https://togithub.com/typeorm/typeorm/issues/6941) [#7516](https://togithub.com/typeorm/typeorm/issues/7516) [#7159](https://togithub.com/typeorm/typeorm/issues/7159) - query builder negating with "NotBrackets" for complex expressions ([#8476](https://togithub.com/typeorm/typeorm/issues/8476)) ([fe7f328](https://togithub.com/typeorm/typeorm/commit/fe7f328fd5b918cab2e7301d57c62e81d9ff34f3)) - separate update events into update, soft-remove, and recover ([#8403](https://togithub.com/typeorm/typeorm/issues/8403)) ([93383bd](https://togithub.com/typeorm/typeorm/commit/93383bd2ee6dc8c22a5cfc0021334fe199da81dc)), closes [#8398](https://togithub.com/typeorm/typeorm/issues/8398) - soft delete recursive cascade ([#8436](https://togithub.com/typeorm/typeorm/issues/8436)) ([d0f32b3](https://togithub.com/typeorm/typeorm/commit/d0f32b3a17be9ffe9fbc6112e5731bbac91c3691)) - sqlite attach ([#8396](https://togithub.com/typeorm/typeorm/issues/8396)) ([9e844d9](https://togithub.com/typeorm/typeorm/commit/9e844d9ff72fae72578399e24464cd7912c0fe5e)) ##### Reverts - migration:show command must exist with zero status code (Fixes [#7349](https://togithub.com/typeorm/typeorm/issues/7349)) ([#8185](https://togithub.com/typeorm/typeorm/issues/8185)) ([e0adeee](https://togithub.com/typeorm/typeorm/commit/e0adeee48eeb0d5412aa5c0258f7c12e6b1c38ed)) ##### BREAKING CHANGES - update listeners and subscriber no longer triggered by soft-remove and recover ### [`v0.2.41`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0241-httpsgithubcomtypeormtypeormcompare02400241-2021-11-18) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.40...0.2.41) ##### Bug Fixes - add `retryWrites` to `MongoConnectionOptions` ([#8354](https://togithub.com/typeorm/typeorm/issues/8354)) ([c895680](https://togithub.com/typeorm/typeorm/commit/c895680dce35f0550f48d92d7dd1a5fb48ab4135)), closes [#7869](https://togithub.com/typeorm/typeorm/issues/7869) - create typeorm_metadata table when running migrations ([#4956](https://togithub.com/typeorm/typeorm/issues/4956)) ([b2c8168](https://togithub.com/typeorm/typeorm/commit/b2c8168514b23671080e6d384e381e997fbaa11e)) - db caching won't work with replication enabled ([#7694](https://togithub.com/typeorm/typeorm/issues/7694)) ([2d0abe7](https://togithub.com/typeorm/typeorm/commit/2d0abe7140a0aec40d50c15acd98633483db3e29)), closes [#5919](https://togithub.com/typeorm/typeorm/issues/5919) - incorrect composite `UNIQUE` constraints detection ([#8364](https://togithub.com/typeorm/typeorm/issues/8364)) ([29cb891](https://togithub.com/typeorm/typeorm/commit/29cb89123aaf705437927a8c6ed23204422b71cc)), closes [#8158](https://togithub.com/typeorm/typeorm/issues/8158) - Postgres enum generates unnecessary queries on schema sync ([#8268](https://togithub.com/typeorm/typeorm/issues/8268)) ([98d5f39](https://togithub.com/typeorm/typeorm/commit/98d5f39e35b6e5dd77ae2aa60f80f4ac98249379)) - resolve issue delete column null on after update event subscriber ([#8318](https://togithub.com/typeorm/typeorm/issues/8318)) ([8a5e671](https://togithub.com/typeorm/typeorm/commit/8a5e6715e2d32da22c2fa71a14a7cf1fe897a159)), closes [#6327](https://togithub.com/typeorm/typeorm/issues/6327) ##### Features - export interfaces from schema-builder/options ([#8383](https://togithub.com/typeorm/typeorm/issues/8383)) ([7b8a1e3](https://togithub.com/typeorm/typeorm/commit/7b8a1e38f269ba329a153135e12e1a21274b3a18)) - implement generated columns for postgres 12 driver ([#6469](https://togithub.com/typeorm/typeorm/issues/6469)) ([91080be](https://togithub.com/typeorm/typeorm/commit/91080be0cd35a5ee9467d4b50b6b7fb5421ac800)) - lock modes in cockroachdb ([#8250](https://togithub.com/typeorm/typeorm/issues/8250)) ([d494fcc](https://togithub.com/typeorm/typeorm/commit/d494fccc9c6a2d773bcb411ba746a74539373eff)), closes [#8249](https://togithub.com/typeorm/typeorm/issues/8249) ### [`v0.2.40`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0240-httpsgithubcomtypeormtypeormcompare02390240-2021-11-11) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.39...0.2.40) ##### Bug Fixes - BaseEntity finder methods to properly type-check lazy relations conditions ([#5710](https://togithub.com/typeorm/typeorm/issues/5710)) ([0665ff5](https://togithub.com/typeorm/typeorm/commit/0665ff5473d075e442f3a93f665bbe087bdf29de)) ##### Features - add depth limiter optional parameter when loading nested trees using TreeRepository's findTrees() and findDescendantsTree() ([#7926](https://togithub.com/typeorm/typeorm/issues/7926)) ([0c44629](https://togithub.com/typeorm/typeorm/commit/0c44629c83c48c27448e7e3cb39faf26994e6e56)), closes [#3909](https://togithub.com/typeorm/typeorm/issues/3909) - add upsert methods for the drivers that support onUpdate ([#8104](https://togithub.com/typeorm/typeorm/issues/8104)) ([3f98197](https://togithub.com/typeorm/typeorm/commit/3f981975d4347483937547feaa8fa4f63b81a83c)), closes [#2363](https://togithub.com/typeorm/typeorm/issues/2363) - Postgres IDENTITY Column support ([#7741](https://togithub.com/typeorm/typeorm/issues/7741)) ([969af95](https://togithub.com/typeorm/typeorm/commit/969af958ba27282b9594140a7e2d58dba1192830)) ##### Reverts - "feat: use char(36) for uuid representation in mysql ([#7853](https://togithub.com/typeorm/typeorm/issues/7853))" ([#8343](https://togithub.com/typeorm/typeorm/issues/8343)) ([1588c58](https://togithub.com/typeorm/typeorm/commit/1588c58539e5121dad6b7120f0b5f83f43f1532f)) - regression in ordering by the relation property ([#8346](https://togithub.com/typeorm/typeorm/issues/8346)) ([#8352](https://togithub.com/typeorm/typeorm/issues/8352)) ([0334d10](https://togithub.com/typeorm/typeorm/commit/0334d104d9ce93c8cb079449ce98ffbdc64219c2)), closes [#3736](https://togithub.com/typeorm/typeorm/issues/3736) [#8118](https://togithub.com/typeorm/typeorm/issues/8118) ### [`v0.2.39`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0239-httpsgithubcomtypeormtypeormcompare02380239-2021-11-09) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.38...0.2.39) ##### Bug Fixes - attach FOR NO KEY UPDATE lock to query if required ([#8008](https://togithub.com/typeorm/typeorm/issues/8008)) ([9692930](https://togithub.com/typeorm/typeorm/commit/96929302a4dc27a19e94c5532a3ae76951e52552)), closes [#7717](https://togithub.com/typeorm/typeorm/issues/7717) - cli should accept absolute paths for --config ([4ad3a61](https://togithub.com/typeorm/typeorm/commit/4ad3a61037ad9ead998665d2857d6e4725d7b718)) - create a different cacheId if present for count query in getManyAndCount ([#8283](https://togithub.com/typeorm/typeorm/issues/8283)) ([9f14e48](https://togithub.com/typeorm/typeorm/commit/9f14e488281fb08d8ea1a95c6cc363e1234fa307)), closes [#4277](https://togithub.com/typeorm/typeorm/issues/4277) - defaults type cast filtering in Cockroachdb ([#8144](https://togithub.com/typeorm/typeorm/issues/8144)) ([28c183e](https://togithub.com/typeorm/typeorm/commit/28c183e9df562e2eb1e3c93afbd1d4687b1b0846)), closes [#7110](https://togithub.com/typeorm/typeorm/issues/7110) [#7110](https://togithub.com/typeorm/typeorm/issues/7110) - do not generate migration for unchanged enum column ([#8161](https://togithub.com/typeorm/typeorm/issues/8161)) ([#8164](https://togithub.com/typeorm/typeorm/issues/8164)) ([4638dea](https://togithub.com/typeorm/typeorm/commit/4638dea55d0e9239a62fb3143cd96988bf07bc68)) - NativescriptQueryRunner's query method fails when targeting es2017 ([#8182](https://togithub.com/typeorm/typeorm/issues/8182)) ([8615733](https://togithub.com/typeorm/typeorm/commit/861573377bb33b73232399c21b1b3a5c07b58036)) - OneToManySubjectBuilder bug with multiple primary keys ([#8221](https://togithub.com/typeorm/typeorm/issues/8221)) ([6558295](https://togithub.com/typeorm/typeorm/commit/655829592ee10aaa5d28a96691ada0d5510899ea)) - ordering by joined columns for PostgreSQL ([#3736](https://togithub.com/typeorm/typeorm/issues/3736)) ([#8118](https://togithub.com/typeorm/typeorm/issues/8118)) ([1649882](https://togithub.com/typeorm/typeorm/commit/1649882d335587ac78d2203db3a7ab492a942374)) - support DeleteResult in SQLiteDriver ([#8237](https://togithub.com/typeorm/typeorm/issues/8237)) ([b678807](https://togithub.com/typeorm/typeorm/commit/b6788072c20b5f235df9272625c3d1d7522d27e0)) ##### Features - add `typeorm` command wrapper to package.json in project template ([#8081](https://togithub.com/typeorm/typeorm/issues/8081)) ([19d4a91](https://togithub.com/typeorm/typeorm/commit/19d4a914a5da2c28f1eb4ed1c28a52db7dc809d0)) - add dependency configuraiton for views [#8240](https://togithub.com/typeorm/typeorm/issues/8240) ([#8261](https://togithub.com/typeorm/typeorm/issues/8261)) ([2c861af](https://togithub.com/typeorm/typeorm/commit/2c861afaef839f33b5cf1cc2b3bcf8b6e4a0be4f)) - add relation options to all tree queries ([#8080](https://togithub.com/typeorm/typeorm/issues/8080)) ([e4d4636](https://togithub.com/typeorm/typeorm/commit/e4d46363917db57a9107048b973b6a12be8d61fd)), closes [#8076](https://togithub.com/typeorm/typeorm/issues/8076) - add the ability to pass the driver into all database types ([#8259](https://togithub.com/typeorm/typeorm/issues/8259)) ([2133ffe](https://togithub.com/typeorm/typeorm/commit/2133ffea9c678841bf3537838777d9a5fec3a00e)) - more informative logging in case of migration failure ([#8307](https://togithub.com/typeorm/typeorm/issues/8307)) ([dc6f1c9](https://togithub.com/typeorm/typeorm/commit/dc6f1c91be29e88466614eb8b8d21a92659cfd0b)) - support using custom index with SelectQueryBuilder in MySQL ([#7755](https://togithub.com/typeorm/typeorm/issues/7755)) ([f79ae58](https://togithub.com/typeorm/typeorm/commit/f79ae589cd1a658fea553cb57abc2a41a46523f8)) ##### Reverts - Revert "fix: STI types on children in joins ([#3160](https://togithub.com/typeorm/typeorm/issues/3160))" ([#8309](https://togithub.com/typeorm/typeorm/issues/8309)) ([0adad88](https://togithub.com/typeorm/typeorm/commit/0adad8810e15b8d00259a2635e1c50e85598e1ed)), closes [#3160](https://togithub.com/typeorm/typeorm/issues/3160) [#8309](https://togithub.com/typeorm/typeorm/issues/8309) ### [`v0.2.38`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0238-httpsgithubcomtypeormtypeormcompare02370238-2021-10-02) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.37...0.2.38) ##### Bug Fixes - prevent using absolute table path in migrations unless required ([#8038](https://togithub.com/typeorm/typeorm/issues/8038)) ([e9366b3](https://togithub.com/typeorm/typeorm/commit/e9366b33ddff296de1254019589b85e40aa53e12)) - snakecase conversion for strings with numbers ([#8111](https://togithub.com/typeorm/typeorm/issues/8111)) ([749511d](https://togithub.com/typeorm/typeorm/commit/749511d981f6b9a1a08113b23e8779a91cda78f8)) - use full path for table lookups ([#8097](https://togithub.com/typeorm/typeorm/issues/8097)) ([22676a0](https://togithub.com/typeorm/typeorm/commit/22676a04c30b3b49a61003320dfad3ecad3791e8)) ##### Features - support QueryRunner.stream with Oracle ([#8086](https://togithub.com/typeorm/typeorm/issues/8086)) ([b858f84](https://togithub.com/typeorm/typeorm/commit/b858f84e6fb15f801f2564088428d250d1c59e18)) ### [`v0.2.37`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0237-httpsgithubcomtypeormtypeormcompare02360237-2021-08-13) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.36...0.2.37) ##### Bug Fixes - allow periods in parameter identifiers ([#8022](https://togithub.com/typeorm/typeorm/issues/8022)) ([4201938](https://togithub.com/typeorm/typeorm/commit/420193892ffe857c532130c0c7b18dcc4c8d38e2)) - ConnectionManager `connections` property should include list of `Connection`s ([#8004](https://togithub.com/typeorm/typeorm/issues/8004)) ([2344db6](https://togithub.com/typeorm/typeorm/commit/2344db60c4314da31885f5686e94bb6dcb203a96)) - entity value for date columns that are related ([#8027](https://togithub.com/typeorm/typeorm/issues/8027)) ([5a3767f](https://togithub.com/typeorm/typeorm/commit/5a3767f58f6ef355b01cf6e92342401a051a369c)) - handle brackets when only one condition is passed ([#8048](https://togithub.com/typeorm/typeorm/issues/8048)) ([ab39066](https://togithub.com/typeorm/typeorm/commit/ab39066f182d357fcc999cd976510c0e2a61d6de)) - handle enums with multiple apostrophes in MySQL ([#8013](https://togithub.com/typeorm/typeorm/issues/8013)) ([37c40a6](https://togithub.com/typeorm/typeorm/commit/37c40a610caecfc3b27b48a87b0e98d715f23395)), closes [#8011](https://togithub.com/typeorm/typeorm/issues/8011) - include all drivers in driverfactory error message ([#8061](https://togithub.com/typeorm/typeorm/issues/8061)) ([fbd1ef7](https://togithub.com/typeorm/typeorm/commit/fbd1ef74e84b59ef0b8d99e311f0aced902190e6)) - resolve not returning soft deleted relations with withDeleted find option ([#8017](https://togithub.com/typeorm/typeorm/issues/8017)) ([65cbcc7](https://togithub.com/typeorm/typeorm/commit/65cbcc79bceac4cf8d15dec8c558dcbc9a037220)) - SAP HANA inserts used incorrect value for returning query ([#8072](https://togithub.com/typeorm/typeorm/issues/8072)) ([36398db](https://togithub.com/typeorm/typeorm/commit/36398dbe467274a9ac08a013ed4daaf307ee2de2)) - some drivers set the wrong database name when defined from url ([#8058](https://togithub.com/typeorm/typeorm/issues/8058)) ([a3a3284](https://togithub.com/typeorm/typeorm/commit/a3a32849c04a83adbf775fcf07843a934551dbfb)) - throw error when not connected in drivers ([#7995](https://togithub.com/typeorm/typeorm/issues/7995)) ([cd71f62](https://togithub.com/typeorm/typeorm/commit/cd71f62cb8125d1bbd92b341aa2eea1de0ac3537)) ##### Features - add relations option to tree queries ([#7981](https://togithub.com/typeorm/typeorm/issues/7981)) ([ca26297](https://togithub.com/typeorm/typeorm/commit/ca26297484542498b8f622f540ca354360d53ed0)), closes [#7974](https://togithub.com/typeorm/typeorm/issues/7974) [#4564](https://togithub.com/typeorm/typeorm/issues/4564) - add serviceName option for oracle connections ([#8021](https://togithub.com/typeorm/typeorm/issues/8021)) ([37bd012](https://togithub.com/typeorm/typeorm/commit/37bd0124dc81c957b2a036436594ae8c4606eb6c)) - add support to string array on dropColumns ([#7654](https://togithub.com/typeorm/typeorm/issues/7654)) ([91d5b2f](https://togithub.com/typeorm/typeorm/commit/91d5b2fc374c2f7b1545d40ee76577272de21436)) - support Oracle Implicit Results ([#8050](https://togithub.com/typeorm/typeorm/issues/8050)) ([fe78bee](https://togithub.com/typeorm/typeorm/commit/fe78bee3725efef47d5be6f924b9caf13f3299a7)) ### [`v0.2.36`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0236-httpsgithubcomtypeormtypeormcompare02350236-2021-07-31) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.35...0.2.36) ##### Bug Fixes - add deprecated `WhereExpression` alias for `WhereExpressionBuilder` ([#7980](https://togithub.com/typeorm/typeorm/issues/7980)) ([76e7ed9](https://togithub.com/typeorm/typeorm/commit/76e7ed943779b940212c4e453d97028b5ffed7d0)) - always generate migrations with template string literals ([#7971](https://togithub.com/typeorm/typeorm/issues/7971)) ([e9c2af6](https://togithub.com/typeorm/typeorm/commit/e9c2af610a1c9a632605b71d67b97e048be2e29e)) - use js rather than ts in all `browser` package manifests ([#7982](https://togithub.com/typeorm/typeorm/issues/7982)) ([0d90bcd](https://togithub.com/typeorm/typeorm/commit/0d90bcdc8c77f2080aa200fe9f4f962b7b01c9ee)) - use nvarchar/ntext during transit for SQLServer queries ([#7933](https://togithub.com/typeorm/typeorm/issues/7933)) ([62d7976](https://togithub.com/typeorm/typeorm/commit/62d79762dbfe58219a5673ba4d404fe9f2e40436)) ##### Features - add postgres connection option `applicationName` ([#7989](https://togithub.com/typeorm/typeorm/issues/7989)) ([d365acc](https://togithub.com/typeorm/typeorm/commit/d365acca68069d0bd9acea5b45a73d7f4c1f4d8f)) ### [`v0.2.35`](https://togithub.com/typeorm/typeorm/blob/HEAD/CHANGELOG.md#0235-httpsgithubcomtypeormtypeormcompare02340235-2021-07-28) [Compare Source](https://togithub.com/typeorm/typeorm/compare/0.2.34...0.2.35) ##### Bug Fixes - `entity` to be `PartialConfiguration
📅 Schedule: At any time (no schedule defined).
🚦 Automerge: Disabled by config. Please merge this manually once you are satisfied.
♻ Rebasing: Whenever PR becomes conflicted, or you tick the rebase/retry checkbox.
🔕 Ignore: Close this PR and you won't be reminded about this update again.
This PR has been generated by WhiteSource Renovate. View repository job log here.