As @JohnH suggested, seems like having SET SEARCH_PATH TO XXX at the beginning of each transaction is enough for PgBouncer operating in transactional mode.
SET SEARCH_PATH TO XXX