Thanks, using Class::DBI::SQLite directly makes things easier and eliminates the error I was getting. Then I got a no such column error:

DBD::SQLite::db prepare_cached failed: no such column: true(1) at dbdi
+mp.c line 271 [for Statement "SELECT id
FROM   channel_prefs
WHERE  active = true
"] at /usr/local/lib/perl5/site_perl/5.8.8/Ima/DBI.pm line 398.
[download]

Looks like most of my other issues are mostly due to looking at differing examples then hard coding the data (poorly) into the initial code. Using place holders and/or quoting the key values properly eliminates this column not found problem. I think improper quoting is making it use the key and value together (keeping the value) for the table name.