I guess we do not have any mechanism or proxy that parses query to redirect it to master or replica.
I was playing with crunchy proxy and read that if the application can provide *read hints*, it would redirect those queries to read replicas, else all go to primary.
Does anyone know of a method to define a foreign server to point to a patroni cluster of 2 postgres cluster instances and be able to select between the master for RW and the replica for RO?