Improve postgresql.api's quality

[jwp]

After a recent commit eliminating some deprecation warnings(collections.abc), it was apparent that postgresql.api is in need of some cleanup. Notably, type annotations should be updated to reflect modern usage.