Maybe this can help https://github.com/awslabs/pgbouncer-rr-patch

It is a pgbouncer fork/patch with query rewriting support.