title: When using parameter for join clause in snowflake, getting wrong result. why?
body: <p>I'm using dbeaver with connection to snowflake database.
  I want to select data with join clause.
  but I need to do it with parameters.
  my code is:</p>
  <pre><code>select count(*) from my_table as a ${join}
  
  var join = 'LEFT JOIN table_b AS b ON a.ID = b.ID AND b.NAME = a.NAME'
  </code></pre>
  <p>when I run the <em>select</em> statement (in dbeaver), I get pop up asking me to fill <code>${join}</code> value,
  I put the value in the textbox and the command runs. I get WRONG result! (1,254,242)</p>
  <p>But when run the following command:</p>
  <pre><code>select count(*) from my_table as a LEFT JOIN table_b AS b ON a.ID = b.ID AND b.NAME = a.NAME
  </code></pre>
  <p>I get correct result (900,254)</p>
  <p>anybody can help please? thank you.</p>