I need to take a user role (i.e., Viewer versus User) into consideration when making queries. How can I check the role in a filter? I’m looking for something simple if possible, i.e. via a sql_on statement, unless templates are the only way to do it....

I am very new to Looker, and am considering using it to replace a very old web service. Part of the service has users running database queries via a web interface, for which Looker is perfect.The other part supports web service queries that are calle...