CI: pre-commit fixups
Fixes 2/3 of the failures on master that im aware of.  sqlalchemy is the one left out.
need to backport these? > need to backport these?

i think these both got introduced in the last day or so  any experience with sqlalchemy?  ive got a branch that is most of the way there, but their deprecation message

```
The Connection.run_callable() method is deprecated and will be removed in a future release.  Use a context manager instead. (deprecated since: 1.4)
```

isnt very helpful in terms of telling me _what_ context manager to use good to go here?  after this, #40471 should get us to green @MarcoGorelli ok for a followup if you want to check / rename the import