How often do you use raw sql?

I was struggling for a couple of days creating a filter/query on a model I created which has multiple manytomany fields. Finally I realized I could just write raw sql, and it worked the first time.

How often do you use raw sql and what for?