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
23493	Defining bilateral lookup transformations	Thomas Chaumeny	nobody	"With the current `Transform` API, transformations are applied to the left-hand side of the lookup only.

For instance, if you define some unaccent `Transform` performing the SQL operation `UNACCENT(...)`, the query below won't return an `Author` with first name Jérémie. Actually, it won't ever return anything.
{{{
Author.objects.filter(first_name__unaccent__iexact=""Jérémie"")
}}}

I think it would be great to be able to define custom transformations which would apply to both sides of the lookup. This would be particularly helpful when you want to perform some lookup insensitive to some SQL transformation (unaccent or other)."	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed			Ready for checkin	1	0	0	0	0	0