There's a version of this for testing SQL database:
You have a .sql file that contains the query and then the response is next AS SQL COMMENTS. The test runner runs the query and verifies that it matches the (comment-delimiter stripped) comment immediately following the query.
Your .sql can contain database creation, inserts, you name it.
Then you run them as part of your CI infrastructure.
Comments
There's a version of this for testing SQL database:
You have a .sql file that contains the query and then the response is next AS SQL COMMENTS. The test runner runs the query and verifies that it matches the (comment-delimiter stripped) comment immediately following the query.
Your .sql can contain database creation, inserts, you name it.
Then you run them as part of your CI infrastructure.