How does Looker API decides the parentheses in the WHERE clause of generated SQL in run_inline_query API. I am getting mismatched parenthesis

I am trying to join 2 tables in the explore using sql_on.The first condition is ON and the second condition, I want to use the value from the row i.e. if user selects cheese then pass item_name=’cheese’ Can this be done in looker ?view: order_items {...