Calculating Top K element per window with Beam SQL

This fails with '`ORDER BY` is only supported for global window..' but when the check is dropped it appears to just work. There is a thread on user@. We should consider just dropping the check.