Currently we only run tests with embedded H2 database, which is often not enough, because different databases do slightly different things and thus even if the code works on H2, it does not mean it will work on all supported databases.

We need to look into testing with multiple databases, preferably using Docker containers as that way we can make sure the databases are always in a clean state (as opposed to using shared DB instances).