title: Is there a way to control the order of child entity, when using one-to-many relationhips?
body: <p>According to <a href="https://developer.android.com/training/data-storage/room/relationships" rel="noreferrer">https://developer.android.com/training/data-storage/room/relationships</a></p>
  
  <p>We can have one-to-many relationships</p>
  
  <pre><code>public class UserWithPlaylists {
      @Embedded public User user;
      @Relation(
           parentColumn = "userId",
           entityColumn = "userCreatorId"
      )
      public List&lt;Playlist&gt; playlists;
  }
  
  @Transaction
  @Query("SELECT * FROM User")
  public List&lt;UserWithPlaylists&gt; getUsersWithPlaylists();
  </code></pre>
  
  <hr>
  
  <p>In both entity <code>User</code> and <code>Playlist</code>, we have added a column named <code>sort_key</code></p>
  
  <p>The purpose is, when we perform query, we can do the following</p>
  
  <pre><code>@Transaction
  @Query("SELECT * FROM User order by sort_key")
  public List&lt;UserWithPlaylists&gt; getUsersWithPlaylists();
  </code></pre>
  
  <p>We can control the order of <code>List&lt;UserWithPlaylists&gt;</code>.</p>
  
  <p>But, how about <code>List&lt;Playlist&gt; playlists</code> child entity? </p>
  
  <p>How can we define a custom query for child entity <code>Playlist</code>, so that we can have control over <code>List&lt;Playlist&gt; playlists</code> ordering?</p>