django.db.utils.NotSupportedError: This backend does not support window expressions.

[schacki]

When executing a query with
.annotate(rank=Window(...))
I get the error django.db.utils.NotSupportedError: This backend does not support window expressions.

I am running
Django==3.0.3
django-mssql-backend==2.8.1
pyodbc==4.0.30

Exactly the same query used to work with previous version of django-pyodbc-azure and django 2.x

I just gave it a try: If in django-mssql-backend/sql_server/pyodbc/features.py I add the attribute supports_over_clause

class DatabaseFeatures(BaseDatabaseFeatures):
supports_over_clause = True
...

it works.

Was this just missed or do I oversee anything?

[OskarPersson]

Feel free to add a PR if this works :)

[schacki]

It works for my use case. however, I am not too much into django database backend. So I am not sure, if my fix has any other negative side effects. Or if there are any other features, that should be added.

But if you want I am happy to provide a PR with my fix

[OskarPersson]

Create one and I'll check it out when I've time :)