title: Databricks getArgument value cannot be used within Spark SQL IN clause
body: <p>I am getting a list of comma separated strings from a databricks notebook widget but I cannot use that value within Spark SQL's IN clause </p>
  
  <p>I am within a %sql cell within the notebook and would like to NOT have to jump into %py or %scala cell type. </p>
  
  <p>Also, I cannot use a select statement within the IN clause as the IN clause is NOT within a select filter. One gets an error: "IN/EXISTS predicate sub-queries can only be used in a Filter" if you try that syntax.</p>
  
  <p>Here ITEM is a widget created like this in a %sql cell</p>
  
  <p>CREATE WIDGET TEXT ITEM DEFAULT "'0111','0112'"</p>
  
  <pre><code>select *
  from items_table
  where ItemSKU in (string(getArgument("ITEM")));
  </code></pre>
  
  <p>or</p>
  
  <pre><code>select *
  from items_table
  where ItemSKU in (getArgument("ITEM"));
  </code></pre>
  
  <p>it does not return any rows</p>
  
  <p>But if I directly substitute the value of the comma separated string in code, i.e. </p>
  
  <pre><code>select *
  from items_table
  where ItemSKU in ('0111','0112');
  </code></pre>
  
  <p>I get the expected result.</p>