[linkerzx]

Yeah the addition of window functions onto sqlite last year was quite a good feature to enable more data use cases with sqlite.

The exclude clause is part of the "window" configuration which defines which row to process, with it you can for instance define a range between all the previous and next rows and check if your data-point looks abnormal.