The CPAN testers are a fairly savvy group. I can't imagine any situation where they would have a problem running your tests; however, it is definitely feasible to to have a little
SQLite sandbox to play around in. You want to look at:
DBIx::Class::Migration. Start with:
DBIx::Class::Migration::Tutorial::Testing.