[Aeolun]

I’m not really sure how to imagine SQL support for something like this. Can you point me anywhere that will give me a better idea?

[cangencer]

It's not very different than normal SQL. Imagine that instead of a finite result set, you instead have a never ending result set. You can also roughly map operations like windowed aggregation into SQL with some additional syntax. This paper gives a pretty good overview, even though we don't fully agree with the model presented here: https://arxiv.org/abs/1905.12133