I'd like to connect to multiple nodes in a CrateDB cluster from pgx and execute queries in a round robin fashion.
Ideally if a node fails queries would be retried on the other nodes.
There's a client in Python that supports clustering but only found PGX for Go from the supported clients page: https://crate.io/docs/crate/clients-tools/en/latest/