I'm told that the purpose of #SQL was to allow people to query the #database without needing to concern themselves with how exactly the database works. Just ask it for what you want, and let it figure out how to make it happen.

Except…if the database isn't indexed appropriately for your query, it'll be slow, so you still do need to know how the database works. 🤔

I wonder if RDBMSes should automatically create indexes as needed? But there's probably a reason why they don't.