Sorting, Grouping and SQlite on Mobile when using YouTube Data API

I have a couple of scenarios that I want to address for the user that is using the mobile app to extract summaries based on YouTube videos.

Although the API calls aren't that frequent, I still need some manipulation of the data that SQLite might be able to do better than a custom function.

1. Create a list of the Playlist Names for which a Compaction is IN. This allows the User to filter from a list of Playlist Names to look at specific Compactions.
2. Enable sorting and reordering in any playlist.
3. Possibly reduce making so many API calls to YouTube (although this is not that important really for a while)

The real pain I am feeling is not being able to reorder.

Reordering with the Firebase index is what the docs show, but here's their warning:

Reordering items in a Firebase query is only suited for smaller lists. For larger datasets, this method can be inefficient and might lead to performance issues. Additionally, frequent writes and updates to Firebase can increase costs significantly.