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
36218	allow annotate to override model's fields	Jan Napieralski		"I want to modify the QuerySet field such that it is fetched from DB and its real field is redacted. For example fetching some employee data, but replacing all the emails and phone numbers to NULL's because of some security or role flag in the API resolver for this

Currently the .annotate() method doesn't allow for the overlap of output field with model field. I have seen, that the way to handle it is to call .values() excluding the overwritten field, but in the large models with many fields or queries with joins, its not realistically possible to know what fields will be used when doing this QuerySet manipulation. The .deffer() doesn't work neither

I propose some flag to the .annotate() for allowing to overlap and essentially overwrite the model field, bc currently the only way without evaluating it, is the .extra()"	New feature	closed	Database layer (models, ORM)	5.1	Normal	wontfix	QuerySet.extra		Unreviewed	0	0	0	0	0	0