Using subqueries with Row Level Security in BigQuery

I've previously posted about row-level security in BigQuery. One of the gotchas back then was the fact that you needed to manually specify what values should the access be filtered for. If only a sub-query was allowed there! Well, a new feature, curr...