Async to Sync Python Conversion

I found quite intereseting the way the psycopg3 maintainers have tried to save the burden of maintaining the double async and sync API support. Instead of doing sync and later async, going the other way around makes more sense.