Postgresql – psycopg2 importError Python3.12 on Windows

I have a python script that I built over the last 2 weeks using python3.10.
The script did run fine 100s of times until I reinstalled python/modules.

I recently upgraded to Python 3.12. I had to pip install all of the modules again but now for some reason when I try to run my script the psycopg2 module keeps failing with the follow error:

packagespsycopg2__init__.py", line 51, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: DLL load failed while importing _psycopg: The specified module could not be found.

I am running my script from Visual Studio Code 1.83 in a powershell prompt.

I have tried uninstalling, clearing pip cache and reinstalling.

I have tried suggested psycopg2-binary package.

I tried updating Microsoft Visual C++ update. I tried reinstalling python 312.

I assume this is some weird windows dependency issue.
Can anyone please help me troubleshoot? I am happy to provide more information if needed.