Support extensive Python environment discovery

[connernilsen]

We'd like to match a lot of the behavior vscode-python supports around finding different interpreters and environments, and to do that, there are a bunch of environment managers we should target. Ideally, we'll be looking at the following:

• Venv
• Conda
• Poetry
• Hatch
• Pyenv
• Pixi
• ActiveState

We already have partial support for a lot of these when the environment is directly sourced for CLI usage, and in the IDE we are using vscode-python, but going through to make sure we're doing the right things in all of the above cases would be great to check.

[BenMawnMahlauNBTC]

Python Interpreter can also sometimes be found at .venv/Scripts instead of .venv/bin/python3

[connernilsen]

Hey @BenMawnMahlauNBTC, thanks for reporting, I'll take a look at adding a search for the interpreter there soon!

[connernilsen]

@BenMawnMahlauNBTC actually I just realized the way it's implemented now will work for finding at .venv/Scripts! Let me know if you start running into problems with that and we can open a new issue.

[yangdanny97]

+1 for poetry