I am working on a helper module that adds support for window functions. A prototype is at https://github.com/robrwo/DBIx-Class-Helper-ResultSet-WindowFunctions if you are interested.