Hacker News new | ask | show | jobs
by throwaway8689 1182 days ago
But what do you call a query? I've seen joins described as 'advanced' in some places.
1 comments

I was thinking a basic SELECT X FROM Y WHERE Z Sql query that can be learned in a day by someone familiar with programming. I don’t know enough to know what qualifies as advanced.
That's fair enough if your job is in front end or whatever and you just need to use a table or view that someone else built for you.

I comment I read somewhere was that SQL goes from basic to advanced with nothing in between. It's a slippery slope of course: you start writing your own query and then you figure a more sophisticated query would be helpful and pretty soon you're having to care about optimisation and indexes.