Thanks for the workaround. I just implemented it for demo purpose and might be helpful for others. Here is the link:
https://github.com/ramsrib/multi-tenant-app-demo

RLS looks interesting, but it might complicate the design little bit. Like you said, most applications will not have one-to-one mapping for app user to db user. So, you need to use signed session variable.