[itcmcgrath]

Try Cloud Firestore, it has a lot of improvements with querying over the RTDB. I can also confirm sorting/querying is handled server-side. (Disclaimer: I'm the PM for it and use it for my own side-projects)

[sanatgersappa]

Would be even better if there was a graphql frontend like AWS AppSync. Helps structure the data a lot more easily.