PODMASTER wrote me earlier to tell me about SQLite and this post. I've since added a (basically functioning) SQLite producer for the SQL::Translator modules. You'll have to look in CVS as this won't be included in the CPAN release until v0.02:
With this, you should be able to convert MySQL and PostgreSQL schemas to SQLite. Probably there will be things to fix. Patches welcome!
ky