Sql like this,
select id, name, category_id from table1 where {{cat1}}
category table like this,
select id, name from category
How does metabase know i want to get a condition on table1.category_id column?
like this “where table1.category_id in ()”.