I wrote this blog post a while ago. It’s about some of the limitations of Firestore.
I am not a fan of SQL