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 1 year 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 1 year 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 1 year ago
portable, my ass. excuse my french.
each system has it’s own dialect and quirks
lysdexic@programming.dev 1 year 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 1 year 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.