3 ms·
> I find SQL very hard to use when the data schema and/or transformation graph needs to be dynamic If the schema is "dynamic" then I'd accuse the business of b
by bob1029 4y ago
> I find SQL very hard to use when the data schema and/or transformation graph needs to be dynamic
If the schema is "dynamic" then I'd accuse the business of being poorly-defined and not worthy of any development time.
- gilbert_vanova 4y agoThat's great except for when you're interacting with a decrepit data system from 10 years ago with a variable record format. Some things can't be locked in stone, and SQL will leave you out to dry when that's the case.
- lolive 4y agoI use graph database, and resources of the graph are typed with types/supertypes. Relationships also are typed with types/supertypes. And my queries are heavily dependant on that typing structure. Honestly, I cannot live without that feature. [sorry, that is my OOP minute. Continue without me...]