If knex doesn't provide facilities for running migrations outside of a transaction, you're going to have an awful time.

Useful operations like CREATE INDEX CONCURRENTLY can't be run in transactions.