Add self-upgrade command

CLI can now self-upgrade using the original installation backend (uv tool, pipx, pip) with automatic detection of the installer.