Thank you for the detailed explanation! I am not that much of a fan of SQL and much prefer writing things in a JSON like way. I wasn't aware of all of the above options and query languages that exist. I also wondered why document databases such as Firestore didn't support a join option. I'll explore some of these solutions.