How to sort query result by argument of list order?
The query below return all items with id from :ids list. But table and input list have different order. Is there way to add something like pseudocode ORDER BY :ids?
@Query("SELECT * FROM spotify_item_table WHERE type = :type AND itemId IN (:ids)")
fun getPagingSource(type: EntityType, ids: List): PagingSource