Hey @EktaPuri 
as mentioned in the original post this is not optimal for our setup.
"Using dynamic views as an alternative introduces a lot more work and user complexity."

It would be great if there were a way to write to external tables with RLS and a dedicated server.