If you're a SQL fan and using the JVM, JOOQ is pretty much the best thing since sliced bread. It has excellent cross database window support.

http://www.jooq.org/doc/3.8/manual/sql-building/sql-statemen...