we have encountered a challenge. We're searching for a way to access session variables within a Metabase query itself.
Specifically, we have a query that returns data for multiple users. Our goal is to restrict each user's access to only their own data, without creating separate queries for each individual. If there were a way to access a user's email address through their login details within the query, we could use that information to filter the data accordingly.