Michael Voříšek

related with https://github.com/atk4/data/issues/1093

> fixes https://github.com/atk4/data/issues/662 this PR does not fix #662 issue, this PR adds a concept of system scope which might be wanted, but the requirements are mainly to be able...

TODO rebase on develop, it is based on https://github.com/atk4/data/pull/690, only the last 10 commits are relevant (others are from the mentioned PR) - https://github.com/atk4/data/compare/be3cb50a37...d6307b30c3

@mkrecek234 can you please post here a repro code like in https://github.com/atk4/data/issues/1078#issuecomment-1357370201 for your nested usecase?

it seems you somewhat copied the `AggregateModel` testcase from aggregate issue subquery like: ``` ( select `fx_rate` from `account` `_a_8a089c2a7e6c` where `id` = `booking`.`account_id` ) `fx_rate` ``` should be quite...

so no AggregateModel above is needed and `(new Booking($db))->executeCountQuery()` has the same performance problem?

⚠ even more conterintuitive: https://sqlite.org/forum/forumpost/8202db3916

another repro: https://phpstan.org/r/9cdef996-1e77-4334-bc79-1af78d5b4139 I can confirm this issue is present only when assigning into static property.

should be easy fix

Let's work on this collaboratively 😊