title: Android, ROOM query with embedded list of objects
body: <p>I am using <code>ROOM</code> and I am trying to get a vehicle name that has a specific <code>Card.Code</code>.</p>
  
  <p>the entity classes are like that</p>
  
  <pre><code>@Entity(tableName = "vehicles")
  data class Vehicle(
      @PrimaryKey
      @ColumnInfo(name = "id") val id: Int,
      @ColumnInfo(name = "name") val name: String,
      @ColumnInfo(name = "cards") val cards: List&lt;Card&gt;?
  )
  
  @Entity
  data class Card(
      @ColumnInfo(name = "id") val id: Int,
      @ColumnInfo(name = "code") val code: String
  )
  </code></pre>
  
  <p>my issue is that I don't know how to write correctly the SQL query </p>