"over" and "partition" are reserved keywords in postgres 9 – the linked PR allows hibernate to recognise them in the Pgsql dialect.

The query I use:

@Formula("(sum(amount_in_cents) over(partition by account_id order by account_id, account_entry_id))")
public Long getRunningBalanceInDisplayCurrencyCents()