Sometimes I'd rather do python magic than self join correlated sub-queries or write window functions and have it all become a convoluted mess. But I see your point.
edit: i'm still trying to train myself to think in a relational way.
relations are awesome, but it def. takes training! I'd suggest avoiding window functions for pagination.. see http://use-the-index-luke.com/no-offset as one method.
edit: i'm still trying to train myself to think in a relational way.