I know it's like everyone's lost their mind right ?

Nope. You just haven't wrestled with python packages for long enough to appreciate the change.

(zzzeek wrote sqlalchemy, alembic, mako and probably more)

Oh, that explains a lot!

He creates the software and leaves it for others to install. No wonder he does not appreciate what uv does. ;)

Yup I'm a newb