title: how to use where keyword in roomdb query
body: <pre><code>@Entity
  data class User(
      @PrimaryKey val userId: Long,
      val name: String,
      val age: Int
  )
  
  @Entity
  data class Playlist(
      @PrimaryKey val playlistId: Long,
      val userCreatorId: Long,
      val playlistName: String
  )
  
  ata class UserWithPlaylists(
      @Embedded val user: User,
      @Relation(
            parentColumn = &quot;userId&quot;,
            entityColumn = &quot;userCreatorId&quot;
      )
      val playlists: List&lt;Playlist&gt;
  )
  
  @Transaction
  @Query(&quot;SELECT * FROM User&quot;)
  fun getUsersWithPlaylists(): List&lt;UserWithPlaylists&gt;
  </code></pre>
  <p>this example many-one from <a href="https://developer.android.com/training/data-storage/room/relationships" rel="nofollow noreferrer">https://developer.android.com/training/data-storage/room/relationships</a>
  , my question</p>
  <p>if I want to get only users age =10</p>
  <pre><code>    @Query(&quot;SELECT * FROM User where age=10&quot;)
      fun getUsersWithPlaylists(): List&lt;UserWithPlaylists&gt; 
  </code></pre>
  <p>but if I want playlistName =&quot;quran&quot;</p>
  <pre><code>@Query(&quot;SELECT * FROM User where playlistName=quran&quot;)
          fun getUsersWithPlaylists(): List&lt;UserWithPlaylists&gt; 
  </code></pre>
  <p>I <strong>cannot</strong> do this because <strong>roomdb does not</strong> see Playlist table</p>