The second feature is a simple DSL that you can use to create SQL window functions.
SQL window functions behave as aggregate functions over sliding ranges of rows and allow you to perform calculations that would otherwise be very difficult or impossible in standard SQL.