Still dont get why sql uses all caps for keywords. It's one of the few languages that has it as a best practice. I can read C/JavaScript/go just fine without all caps.
I do it anyway to conform.
I do it anyway to conform.
LIMIT 10
SELECT *
FROM wtf
but many DB engines will be unhappy because LIMIT has to be after FROM, etc.
Once you're used to the strict order rules, you can skip reading anything in CAPS as long as the bug you're fixing isn't that they're myspeled or order out of.
If everything is lowercase, you can tune in to spotting the keywords. If it's mixed, it's just confusing.
There's an argument to be made that because SQL is so often quoted in a different language, highlighting isn't often applied.