Can I use window functions like partition by?
I've added some of my own functions to the SQLite engine though, e.g. ElementAt(pos, elements, orderElements) will return the element at position pos in a group, ordered by orderElements. Not exactly window functions, but close.