Yeah but I found myself in that exact position. I provided data to a bunch of business users who don't understand SQL but understand pivot tables extensively.
I have the choice between either spending a few days educating them on how to do SQL, or to give them data in a way that they can use the tools they are already familiar with.
I was too busy to do the former.
The other thing is that SQL sucks at creating pivot tables. It is good when you only want to aggregate in one direction. When you want to aggregat in multiple directions (column A by row, column B by row) the syntax becomes tedious to do by hand.