title: android Room, how to delete multiple rows in the table by id list
body: <p>Having a Android Room with three tables <code>timestamp</code>, <code>index</code>, <code>details</code>, and all three have </p>
  
  <pre><code>@PrimaryKey @ColumnInfo(name = "id") var id: Int = 0
  </code></pre>
  
  <p>having <code>fun clearDataByID(idList: List&lt;Int&gt;)</code>  to clear data from all three tables by the <code>id</code> in the <code>idList</code></p>
  
  <p>Dao as:</p>
  
  <pre><code>@Dao
  interface DataDAO {
  
  
  @Transaction
  fun clearDataByID(idList: List&lt;Int&gt;) {
      deleteDataInTimestamp(idList)
      deleteDataIndex(idList)
      deleteDataDetails(idList)
  }
  
  @Query("delete from timestamp where id in :idList")
  fun deleteDataInTimestamp(idList: List&lt;Int&gt;)
  
  @Query("delete from index where id in :idList")
  fun deleteDataIndex(idList: List&lt;Int&gt;)
  
  @Query("delete from details where id in :idList")
  fun deleteDataDetails(idList: List&lt;Int&gt;)
  }
  </code></pre>
  
  <p>but it gets compiler error (similar for all three)</p>
  
  <pre><code>error: no viable alternative at input 'delete from timestamp where id in :idList'
  public abstract void deleteDataInTimestamp(@org.jetbrains.annotations.NotNull()
  </code></pre>
  
  <p>if delete by single id it worked.  </p>
  
  <p>How to delete by a list of ids?</p>
  
  <pre><code>@Query("delete from timestamp where id = :id")
  fun deleteSingleTimestamp(id: Int)
  </code></pre>