It is always possible. Name one case where it isn't, and I'll tell you how it's possible :)

Web frameworks should handle input (routing, request fields, url query) and output (templates). That's it.

OK, Django ORM, conditional aggregates - these were not possible last time I checked. You can do it at the application level, but say you want to keep the performance up, you need to drop into SQL.