Excessive parentheses when generating a query

[Lelikov]

ORM:

Model.objects.filter(field=Func(F("user__notification_email_types"), function="ANY")

SQL:

..."app_model"."filed" = (ANY("app_user"."notification_email_types")))

Error:

syntax error at or near "ANY"

The reason for the code change in version 4.0. The excessive parentheses around the function ANY
django/db/models/lookups.py

if sql and sql[0] != "(":
    sql = "(%s)" % sql

In version 3.2 everything worked correctly

[Giebisch]

Im pretty sure I had a similar error a few weeks ago. I can't test right now, but if the error still persists, I will be happy to look into it :)

[Aman Pandey]

i would like to look into it

[Mariusz Felisiak]

Thanks for the report, however this behavior was intentionally changed in 170b006ce82b0ecf26dc088f832538b747ca0115 (see also #32673) and we cannot revert it without reintroducing regressions.

As far as I'm aware,ANY requires ARRAY or a subquery on the right-hand side, so I'm not sure how this could work for you 🤔 Nevertheless you can always creating a custom lookup, the following example works for me:

class Any(Lookup):
    def as_sql(self, compiler, connection):
        lhs, lhs_params = self.process_lhs(compiler, connection)
        rhs, rhs_params = self.process_rhs(compiler, connection)
        params = (*lhs_params, *rhs_params)
        return "%s = ANY(%s)" % (lhs, rhs), params

> Note.objects.filter(Any(F("note"), Subquery(Annotation.objects.values("name"))))