The python ssl issue on windows is supposed to show as “unable to get local issuer certificate”. In your case it’s “certificate has expired”. Are you sure that your date/time are set correctly?
There is some system configuration issue on your end.
One painful workaround is to download each patch file by hand and put it in subprojects/packagecache
Thanks for getting back. In order to get closer I did a fully fresh install on a new AWS EC2 instance. The issue was that before I tried other work arounds for python and the certificates on Windows I found while googling this. Apparently they were referring to out dated certificates. Unfortunately, as these are tenth of certificates which are installed here I didn’t find a way to remove these once causing the issue from the local Windows certificate store. Worst case I need to reinstall Windows.
It looks like I got a bit rusty building software packages from source. But eventually this worked:
clean Windows install w/o outdated certificates in the store (in my case new EC2 instance)
visual studio community 2022, with “Local Windows C++” tools installed
python 3.9.13 (!!, recent version don’t work due to deprecated and missing packages)