> - Windows functions: They are wonderful and I love them. But it is not an important factor at all. I disagree or would choose to qualify a number of the thin

> - Windows functions: They are wonderful and I love them. But it is not an important factor at all. I disagree or would choose to qualify a number of the things you wrote, but I'll choose this one because I think it's the most interesting: While window functions are seldom (but not never) used by common application workloads, but I find them pretty important for lowering the barrier of what one-off queries I can write (hence, more questions are economic to answer) to figure out some statistics that assist doing business or solving strange problems. The alternative is to be forced to make a greater number of decisions with less supporting data. This can be applied to any labor-saving device when it comes to reporting, but I think window functions make the cut for me overall, and it's great they are there.