Is window function/analytical function supported by JSON SQL

  1. JSON SQL runs on alasql.
  2. I would like to know whether alasql supports analytical function/ window function such as SUM() OVER (PARTITION BY X)
  3. this is the closest I can find and doesn't seem to support yet Enhance SQL function · Issue #1216 · AlaSQL/alasql · GitHub

Appreciate your response


Great question! It doesn't look like alasql currently supports this. I'm not the most familiar with the PARTITION BY clause but would a GROUP BY work for your use case here? If not, would you mind telling me a little more about your use case?

thanks for getting back Chris. That's fine. I just want to confirm window function is not possible then I can plan on other workarounds.