Window functions are here [1]. (We should add these to the homepage too)
Implementation specific queries can be handled by the Dialect parameter [2], though there's still lots of work to do to build that out.
[1]: https://prql-lang.org/book/transforms/window.html
[2]: https://prql-lang.org/book/queries/dialect_and_version.html