SQL is horrible as a language to read or write. There’s a million different variants, because it lacks so many basic things. And when used in other code, you generally end up string concatinating one language in another language, with all the HORRIBLE bugs something like that brings about.
Imagine Backend People said we should just write adhoc Javascript for the frontend by concatinating the “correct” code in the backend.
sip@programming.dev 11 months ago
relational databases have years of reseach into them, not the query language itself.
sql was built so people other than devs can use it, but we got stuck with it.
normalexit@lemmy.world 11 months ago
SQL has been around and evolving since the 70s. It is an ISO/IEC standard and is portable across a multitude of databases.
https://en.m.wikipedia.org/wiki/SQL
sip@programming.dev 11 months ago
portable, my ass. excuse my french.
each system has it’s own dialect and quirks
lysdexic@programming.dev 11 months ago
That does not mean that SQL, as specified by one of it’s standard versions, is not portable. It just means that some implementations fail to comply with the standard and/or provide their own extensions.
lysdexic@programming.dev 11 months ago
Not really. Being designed with UX in mind, so that it sacrifices conciseness for readability, does not make it something for “people other than devs”.
Likewise, BASIC was also developed with UX in mind, and no one in their right mind would ever claim that it’s not a programming language.