If you switch you vendor, you will probably have to fix manually many things, be it migrations, code, etc. An ORM-based solution is a thing, but then you lose the ability to use vendor-specific behavior, unless your ORM have specific extension for those, and then you're back at square one.
The site clearly says: A simple and language-independent SQL schema migration tool and that it has first-party drivers for SQLite, MySQL and Postgres. I'm guessing it uses the lowest common denominator (the ANSI SQL standard), so any crazy FFI C extensions you wrote might be left in the lurch.