Multiple filters in single query

Hi

If I have mutiple filters in single query and I haven’t braced them in [[]], then will it still consider that part of query or it simply ignores it?
e.g
select * from product
where {{product_category}} AND {{product_price}};

So, if I have kep “Required” toggle button off for “product_price” filter and I also don’t brace it around square brackets ([[{{product_price}}]]), then how would my query look like?

  1. select * from product
    where product_category = ‘cosmetic’ AND product_price = ;
    OR
  2. select * from product
    where product_category = ‘cosmetic’;

Hi @swaga
That’s specifically Field Filters, which are translated to 1=1, when they are not defined as required and is not filled.
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#optional-clauses