Is window function/analytical function supported by JSON SQL

馃挰 Queries and Resources
1
  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

2

Hey @oliver.ng!\

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?

3

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.