Convention for imports

[math-fehr]

We just merged George PR that remove star imports from imports.
I feel that there are other conventions we should follow for imports, and I'm not really aware of the ones that are used in practice.
@georgebisbas, @webmiche, @ingomueller-net, do you have good pointers for conventions that are normally used, and if possible, CIs that would enforce that?

[ingomueller-net]

I have used pylint in a past project and found it quite helpful. It has several checks related to imports, which can enforce a few things conveniently. (The other checks can be deactivated, if only imports should be checked.)

[webmiche]

I have heard that enforcing an order on imports (like we do in the mlir converter) is bad style (here, e.g.).

I feel that the fundamental problem is more in the python bindings than in our code, but I guess changing that would be very hard, so we might want to do some more engineering.

[superlopuh]

ruff decides this for us now!