Please find the attached patch to migrate psycopg2 to psycopg3. I have used psycopg v 3.1.0 which is yet to be released soon. To test the patch, one needs to clone the psycopg3 repo, build it and point it to the pgadmin venv.
For the time being, psycopg2 and psycopg3 both can be configurable via PG_DEFAULT_DRIVER and can be used.
With this patch many SQL Ascii related issues and Range partition related issues are resolved. For example: #7028, # 6575, #4061, #7165.
I have verified some of them but we need to test all of them.
Note: Debugger test cases are still failing, on which I am still working.