Can’t this be somewhat alleviated by running a job native on Postgres or some external one to refresh the views on a schedule? It’s not ideal or realtime but better than having it done as-hoc.