We have the following problem:

We use Flyway, and so we have some SQL scripts that are called to populate / update a database.
Our databases now have to be updated from MySQL 5.7 to 8.0, and consequently some of our scripts are now invalid, as they contain deprecated SQL.
We can’t change the SQL, as Flyway will bail out if it notices changes to SQL that it has already applied to a database.

I assume that there is a known solution for this, but I have been unable to find one.