Bob den Os

feat: add explain support for `SELECT` queries

1

It is best practice when using HANA to use execution plan visualization files to identify the root cause of slow performing queries. This change targets to add native support for...

Currently it is not very common that people develop with `HANA` in their local development setup, but sometimes it is required to validate specific behaviors. This change there for exposes...

Deep UPDATE loses track of relationships

4

### Description of erroneous behaviour When doing a deep `UPDATE` when using an ambiguous `WHERE` clause it creates children without parents. ### Detailed steps to reproduce ```js await INSERT([{ ID:...

chore: unify physical elements check

3

Add an `exists()` function into `cqn2sql` to unify checking whether an element exists in the database. ```js element.virtual // virtual does not exist on the database element.value // calculated column...

It is not allowed in `HANA` or `Postgres` to use the `+` operator on the `boolean` data type. As `SQLite` does not have a `boolean` data type it is allowed...

Currently all deep operations are calculated on the fly and rely on reading the current state of the database and calculating the difference. This PR targets to no longer calculate...

test: Run Postgres tests with version 14 15 16

2

As requested by #364

fix(REVISIT): Ensure safe rollback and release

1

## Description When a database connection encounters an error in a query it will trigger the default rollback mechanism. As all queries including rollback are asynchronous it is possible that...