SQL was designed by COBOL / NATURAL people and was intended to be used by "normal people".
That was part of a larger movement at the time to make programming more accessible.
Unfortunately
(a) that experiment mostly failed
(b) the resulting syntax does not compose well at all
(c) the syntax does not represent the underlying semantics and mathematical operations well at all.
The combined effect is a rather tortured language, as it has been extended over the years.
However, replacing it is equally problematic because of the huge installed base.