For what it's worth, SQL kind of sucks. It's just the de facto choice because it's extremely widespread and good enough for 80% of the use cases out there and w

For what it's worth, SQL kind of sucks. It's just the de facto choice because it's extremely widespread and good enough for 80% of the use cases out there and what's missing can be kludged on top of it, either by specific DB vendors, or by various extensions. It's not too hard to come up with alternatives that improve upon individual aspects of SQL like https://prql-lang.org/ https://prql-lang.org/ but the barrier of entry is about as high as trying to make a huge social media network, most attempts will remain niche. Then again, most software kind of sucks, it's just that some of it also works. For example, the Linux FHS reads like an overcomplicated structure that is the way it is for historical reasons, but works in practice.