Yup, window functions should be a last resort, but sometimes there in no good way around them. For example if you have to paginate on an aggregated query, you need to pull out the total size of the result set. Count on an aggregated query can be done only with window function and without a support for it users have to fall back to native queries.