Personally, I write most of my tests for views etc. as :memory: database in SQLite and test them from within Perl with the Test::More framework.

I once tried to do tests by running sqlite.exe and having

SELECT 'ok' WHERE ...

statements to generate TAP output directly from SQL, but in the end
that proved to be too much hassle.