Some guesses:
- There is some popular non-sql query language that has gained lots of momentum that I just dont know about.
- People are more effective with SQL because they know it so no new and especially existing databases will switch. This is definitely true to some extent, but if this is the whole reason then I guess SQL is pretty good since people rely on it to be effective.
- There is support for it but a few key decision makers are to blame (big data or the MYSQL lobbyists)
- People actually dont dislike SQL that much and/or its not that bad and hackernews is not representative
- These query languages look nice but have technical or performance issues compared to SQL