I guess it depends on what you define as “basic SQL”. Because most people are already used to working with desktop apps, and familiar with the office programs specifically.
You’d essentially have to teach them programming. Its like when people say “terminal is better than GUI” (it’s me, I say that) but then you forget about all of the people who don’t know the difference between a desktop and a modem
It wouldn’t be hard to teach them a graphical representation of SQL, something like Access I guess. Teach them concepts like joins and where clauses, and give them software that abstracts that a bit.
Then add some Excel-like features on top. Everything would end up being SQL at the end of the day, and sysadmins could then tune things to keep them fast (e.g. replicate DBs so poorly optimized queries don’t hurt the whole org, esp. if a dept only needs read access).
Surely its not any harder than teaching them basic SQL.
I guess it depends on what you define as “basic SQL”. Because most people are already used to working with desktop apps, and familiar with the office programs specifically.
You’d essentially have to teach them programming. Its like when people say “terminal is better than GUI” (it’s me, I say that) but then you forget about all of the people who don’t know the difference between a desktop and a modem
It wouldn’t be hard to teach them a graphical representation of SQL, something like Access I guess. Teach them concepts like joins and where clauses, and give them software that abstracts that a bit.
Then add some Excel-like features on top. Everything would end up being SQL at the end of the day, and sysadmins could then tune things to keep them fast (e.g. replicate DBs so poorly optimized queries don’t hurt the whole org, esp. if a dept only needs read access).