my $dbfile = "places.sqlite";
my $dbh = DBI->connect("dbi:SQLite:dbname=$dbfile","","") or die $@;

$dbh->selectall_arrayref("show tables");

Ergibt bei mir:

DBD::SQLite::db selectall_arrayref failed: near "show": syntax error at..