I always did that with integration tests. Put some data in the db. Use the repository aka your sql and validate the results. Most of the times there is a layer

I always did that with integration tests. Put some data in the db. Use the repository aka your sql and validate the results. Most of the times there is a layer around your sql (a repository, a bash script or whatever) that you can use for integration testing.