Syntax error, incorrect syntax near 'over' - while using ROW_NUMBER

[anechaud]

Seems row_number(), rank() etc sql functions are not supported by azure cosmos db sql api yet.
I am trying to fire the below query

SELECT ROW_NUMBER() OVER(ORDER BY ZZWH_CODE) AS rn FROM c

and getting error :

Failed to query item for container contianer_name:
Gateway Failed to Retrieve Query Plan: Message: {"errors":[{"severity":"Error","location":{"start":20,"end":24},"code":"SC1001","message":"Syntax error, incorrect syntax near 'over'."}]}

What could have gone wrong?