title: Room - Select query with IN condition?
body: <p>Is it possible to use SQLite's <code>IN</code> condition with Room?</p>
  
  <p>I'm trying to select a list of items from my database where the value of a certain column (in this case a <code>TEXT</code> column) matches any one of a set of filter values. That's pretty easily done in SQL and SQLite, by my knowledge, just by adding an <code>IN</code> condition to your <code>SELECT</code> statement (<a href="https://www.techonthenet.com/sqlite/in.php" rel="noreferrer">see here</a>). However, I can't seem to make it work with Room.</p>
  
  <p>I keep getting this error:</p>
  
  <pre><code>Error:(70, 25) error: no viable alternative at input 'SELECT * FROM Table WHERE column IN :filterValues'
  </code></pre>
  
  <p>(where the input to the DAO <code>@Query</code>-annotated method is called <code>filterValues</code>)</p>
  
  <p>I have tried three different methods now:</p>
  
  <ol>
  <li>Passing the argument as a <code>List&lt;String&gt;</code></li>
  <li>Passing the argument as a <code>String[]</code></li>
  <li>And lastly passing the argument as simply a <code>String</code>, but formatted as <code>(value_1, value_2, ..., value_n)</code></li>
  </ol>
  
  <p>The last one in particular should work easily, as it will (or at least, it should) directly translate to <code>SELECT * FROM Table WHERE column IN (value_1, value_2, ..., value_n)</code>, which is the exact way you would manually write out the <code>SELECT</code> if you were just accessing the database directly.</p>