go-sqltest

The go-sqltest is a scenario test framework for SQL-compatible databases.
The go-sqltest imports the scenario test files and runs the scenario test to the target SQL-compatible databases as the following.

The scenario testing framework will be used in my SQL-compatible database projects such as go-mysql.
Client
The go-sqltest is implemented using Go and uses standard generic database/sql interfaces, mainly SQL (or SQL-like) databases for clients. Therefore, go-sqltest can run scenario tests against a variety of SQL databases such as MySQL and PostgreSQL by providing drivers for the database/sql interface.
Adding scenario tests
The go-sqltest imports a scenario test file in the test
directory and embeds the file in the helper test function. The scenario test file must have the extension qst
(query scenario test).
A scenario test consists of a combination of a query and an expected response; the EBNF specification is as follows.
scenario-test = (query, response)*
query = SQL
response = JSON response