Not(rant) can anyone give pro's con's of firebase?

I recently started working with it for a side project. I don't know how it compares to other real-time databases, but I note having "complex" querying/sorting of data is next to impossible. If you are use to T-SQL syntax of being able to have multiple AND OR statements you are going to want to scream. Also be aware if you use Firebase App hosting, you can only have one firebase app per TLD. You can't have one running at example.com and another at sub.example.com

@Eat-Sleep-Code good to know I'm predominantly MS stack and have been SQL Server / Oracle for the last 16 Years. I have always wondered about the limitations of noSQL style DB's

Web stuff is all new to me as is app development but a potential customer has requirements of ionic, firebase and some other stuff php etc

If you can host your own, check out rethinkdb.com -- it is a real-time database that apparently supports multiple filters