I use Slick to access Postgres and it does support postgres window functions: https://github.com/tminglei/slick-pg#details
That being said it was also one of the hardest libraries for me to learn. The docs are okay but it seemed like I found more features in peoples github repos that were not documented on the Slick website.