The driver currently only implements the legacy autocommit mechanism. Let's add support for the Python 3.12 `Connection.autocommit` mechanism.