Minor fixes and improvements.

Improvements

Python 3.12 and PostgreSQL 16 support (#1084)
(by @elprans in deea86c)
Add support for tuple-format custom codecs on composite types (#1061)
(by @elprans in 922fcd1)
Support target_session_attrs in URL format, add tests (#1073)
(by @elprans in 7cb4e70)
Infinity numeric support (#1067)
(by @krokoziabla in 0c3bf60 for #1020)
Add support for the WHERE clause in copy_to methods (#941)
(by @kaylynn234 in b7ffab6)
Add query logging callbacks and context manager (#1043)
(by @dcwatson in b2697ff)

Fixes

When prepared statements are disabled, avoid relying on them harder (#1065)
(by @elprans in cbf64e1)
Handle environments with HOME set to a not-a-directory (#1063)
(by @elprans in af922bc)
Fix handling of non-ASCII passwords (#1062)
(by @elprans in 89d5bd0)
Disable JIT while doing type introspection (#1082)
(by @elprans in f21ebf6)
Remove connection parameter caching in Pool (#1053)
(by @ermakov-oleg in 4ddb039)
Switch to Python 3.12-style wait_for (#1086)
(by @elprans in 4bdd8a7)
Update automatic PostGIS type conversion for Shapely 2.0 (#1085)
(by @ChimneySwift in 8b45beb)
Use the timeout context manager in the connection path (#1087)
(by @elprans in 313b2b2)
Small fix for documentation on using SSL in Connection (#995)
(by @ScottFred in ccc7baf)
Use cleanup_ctx in pool usage doc (#878)
(by @ir4y in 70c8bd8)
Close cursor portals once the iterator is exhausted (#1088)
(by @elprans in ca9f03b)
Cut BaseProtocol circular reference on close. (#1049)
(by @pteromys in 93a6f79)
Allow passing hosts as tuples to connect() (in addition to lists) (#1021)
(by @lezram in d7faaff)