Not exactly pythonic, but on previous project with Django I had a bit similar issue with redshift backend lacking behind in Django support.
Settled on using github.com/golang-migra...
Figured that I'd probably settle on raw SQL migrations there anyway, so why write a system from scratch.

If it's loud, in shared workspace and not in kitchen, dining or rest area, then everyone is welcomed to join in. Chime in and derail the conversation ;).

If no pre-commit plugin exists, I essentially hook the given command as a system-type local hook.

I've seen people seeing pre-commit first time who were pleasantly surprised by it.

For me, pre-commit took over a linter entry point, running linters, formatters, type-checkers for Python, Go, restructured text documentation, Terraform, and others.