Is there a way in looker to execute dynamic queries
i.e I have a mapping table which can tell me the preferred column name for each client.
Based on the column name from the mapping table , I have to query another table
@set mapped_column_name = select column from mapping_table where client_id =”client 1”;
select * from another_table group by (mapped_column_name).
Does looker support this?