can support for window function be added in both mysql postgresql Sample query: Select field1, sum(field2) over (partition by field3) as fieldn1 from table1