title: How can I use SQL "NOT IN" Operator with Room
body: <pre><code>@Query("UPDATE items SET saved=:saved WHERE id IN :itemsIds") // works
  abstract void method1(List&lt;Long&gt; itemsIds, boolean saved);
  
  @Query("UPDATE items SET saved=:saved WHERE id NOT IN :itemsIds") // ERROR!!
  abstract void method2(List&lt;Long&gt; itemsIds, boolean saved);
  
  @Transaction
  void updatePreferredItems(@NonNull List&lt;Long&gt; prefItems) {
      method1(prefItems, true);
      method2(prefItems, false);
  }
  </code></pre>
  
  <p>My objective is from an ids list I would like to to update the field <em>saved</em> of all the items to true if item id belong to ids list, false otherwise.</p>
  
  <p>Why the second query is generating a compile error ?</p>
  
  <p>Is this the right approach ?</p>