Hello, does pinot support sql windowing?

No. Not yet. You can achieve that via presto/trino connector.. Another option depending on your usecase and if you are ok with approximate results, you can use theta sketch