It's a case of using the right tool for the right job. It is indeed lacking for complex queries, and those use cases should probably stick with SQL. I've been

It's a case of using the right tool for the right job. It is indeed lacking for complex queries, and those use cases should probably stick with SQL. I've been surprised over five years of using Firebase how often complex queries weren't necessary, though! I highly recommend using Firebase if you want realtime data synchronization and great client libraries as well as easy auth and some nice integrations with cloud functions and the like.