Some complexity is accidental (how do I do this gnarly window function and get the 3rd highest value from the previous week this time last year except on the first week of the quarter), and some is essential (why is the data like this?).

People confuse the two, and rightfully dislike the former while dangerously resenting the latter.