Do you have any recommendations on where to read about the problems of SQL? When you put it this way, clearly my assertion that "SQL isn't bad" needs a review.
I ask for recommendations because I don't know what I don't know. I've read a few criticisms of SQL where some conclude "just use mongodb". A good recommendation from an expert helps avoid faulty understanding.