https://arrow.apache.org/flight-sql-postgresql/current/client.html We have ADBC (C API) client examples but Python API will be also useful.