I can't help but wonder if devs feel this way because several full stack web frameworks default to using SQLite in their dev environment. That, and the name ("lite").

Of course that's not at all true, SQlite is an incredibly robust production-grade tool that is deployed to billions of devices, but it sure feels like that caused damage to the brand.

That said I think this is actually becoming less of an issue these days. Certainly feels like there has been a resurgence in SQLite appreciation and usage over the past few years.