NXP-12910: improve subtree query performance on H2 and MySQL
NXP-12907: revert NXP-12258 and implement pre-creation of complex properties to avoid concurrency issues