Add check to warn against usage of querysets in boolean expressions

[sevdog]

Django querysets can be used in a python boolean expression (ie: bool(qs) or if qs:), however in many cases this is considered a bad practice in django since the __bool__ method causes the whole queryset to be evaluated. The best practice suggests to use .exists() instead.

If possible, it would be very useful to have a check/test which warns against these usage.

[jacobtylerwalls]

That's a great document. In fact, right below the passage you linked, it warns not to overuse exists(). So this check would really only be useful if it could tell with confidence that the queryset is not evaluated afterward.