How we run database migrations with Flyway, jOOQ, and testcontainers

Airbyte is an open-source data integration framework that uses Java as its main language for backend development, Gradle as its build tool, jOOQ as the object-relational mapping library (ORM), and Flyway to manage database migrations. The company has developed a unique approach to chaining these tools together for maintaining and evolving their internal data models. They write all of their Flyway migration scripts in Java rather than SQL, run local migrations against databases in testcontainers instead of physical databases, and wrap the Flyway migration inside their own classes to add extra features to the migration process.