I know PHP has its flaws, as does SQL (hence non-sql databases have long been gaining in popularity) and I'm sure NodeJS probably does too (I'm no expert on it), but his opinion lacks any objective comparison. It's worth taking time to read opinion on the matter but you won't ever satisfy this guy if you make the switch, ever, even if everything is better tenfold.
I wouldn't group PHP and SQL together like that. PHP is a clusterfuck. I code it professionally from time to time and I dislike it a lot. I have coded some 20+ languages and while Perl can give you a proper headache, it's not as broken as PHP. SQL is a language and for what it aim to do, it's perfectly fine. It's RDBMS that are going out of style, not SQL per se. Relational databases do some things great and quite a few things not so great. RDBMS' have also dominated the industry for years. Thankfully the industry is now churning out products that do a task properly instead of trying to shoehorn any task into a specific product (I'm looking at you, Oracle!).
If you want to look up a cool database, check out http://neo4j.com/ I really want to convert a RDBMS based system to Neo4j to test it out. I should really test Mongo as well.