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
36690	Use case for EXTRA()	Gareth Leake		Django's ORM leverages UPPER() and casts to text `UPPER(...)::text` when doing a case insensitive search. This is not adequately performant for our use case, and loses the use of an index due to the UPPER() call. The `extra()` function allows me to explicitly make a case insensitive ILIKE call on postgres.	Uncategorized	closed	Uncategorized	5.2	Normal	invalid	QuerySet.extra		Unreviewed	0	0	0	0	0	0