> The main selling point to me was that you could write a lot of wicked fast integration tests on top of H2 and exercise your ORM
Nowadays in the age of containers you can spin up the database you are using in production easily in a few seconds. Unless you are stuck with using one of the old commercial monsters like Oracle this is not really worth doing anymore.