I'm not sure which part would require an improvement because there many assumptions that turned out to be wrong, and those cannot be addressed.

Many assumptions that turned out to be wrong? Please list them.

Also, the Spring Data JPA team seems to have made such assumptions?
Doesn't it tell that something maybe wrong with the current behavior?