[Project] Query and backend functions improvements

[CCuskley]

This is a general parent ticket for an ongoing project to improve the speed, efficiency, and clariity of data queries and firebase functions.