With Spring Data JPA, you can easily create database queries and test them with an embedded H2 database.

But sometimes, testing against a real database is much more useful, especially if we use queries tied to a specific database implementation.