id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
35491	QuerySet.extra use case. Unnest array and make it lower. and make it an array again.	june	nobody	"I had used extra() for annotating Arrayfield with lower cases and filter out with another array intersection.

Below is what I used for

```
        lower_value = [v.lower() for v in value]
        numbers = Numeric.objects.extra(
            where=[f""ARRAY(SELECT lower(unnest({array_field}))) && %s::text[]""],
            params=[lower_value],
        )
```

I need to unnest arrayfield first and make each elements lowercase, and make it an Array again. 
and then need to check overlay with another array.
"	New feature	closed	Database layer (models, ORM)	4.2	Normal	invalid	QuerySet.extra		Unreviewed	0	0	0	0	0	0