3 ms·
I found that SQL is actually an excellent language for people with no coding background. Especially in the BI field it's easy to teach people SQL so that they c
by dx034 10y ago
I found that SQL is actually an excellent language for people with no coding background. Especially in the BI field it's easy to teach people SQL so that they can perform their own (often quite powerful) queries. It's much easier than learning a proper programming language.
A re-design might be nice for programmers, but would likely lock out most people with no programming backgrounds who work on databases.
- maxxxxx 10y agoMaybe simple queries like "Select where" are intuitive for non-programmers but once you start joining tables things get pretty ugly. Also, the syntax for UPDATE is totally different from INSERT although they do similar things. Why does UPDATE use key value pairs but INSERT uses list of column names followed by list of values? Since Javascript is the best programming language ever (so I hear :-) ) maybe using Javascript syntax and objects would be nice.
- dx034 10y agoI absolutely agree that INSERT statements should use key value pairs. It would eliminate many errors where columns were switched accidentally.