Comment 8 for bug 1846606

I can next week - however the solution is at best a workaround as alembic/sqla don't have an immediate fix for dropping and re-creating the constraint that gets auto-generated.

The fix is to use create_constraint=False when creating sa.Boolean column types so they don't get generated in the first place - that could be limited to MySQL thus maintaining the pre MySQL 8 behaviour.