As far as I know, SQL won because it was used by the first commercially successful relational database systems, and then other systems entering the marked neede

As far as I know, SQL won because it was used by the first commercially successful relational database systems, and then other systems entering the marked needed to support it. It is a bit like JavaScript. Everyone knows it has its flaws and it is easy to imagine a better alternative, but it is "good enough".