I don't think the author is trying to call out SQLite as somehow better than others database tech - just that most people perceive SQLite to be a tool for development or exploration when in fact it much more powerful than most believe
Not sure about that. I can't recall having seen PostgreSQL being referred to as toy database. I have seen however texts cautioning SQLite in production use, e.g. in [1], [2].