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
29710	Support simple-style CASE expressions	Tom Forbes	nobody	"Currently we only support one variant of the SQL CASE statement:

{{{
CASE WHEN a = 1 THEN 'one' WHEN a = 2 THEN 'two' ELSE '?' END
}}}

There is a simpler version when you just need to do an exact check on a single value:

{{{
CASE a WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE '?' END
}}}

This may be easier for databases to optimize against, especially if you are producing large statements with many cases (https://code.djangoproject.com/ticket/23646)"	New feature	closed	Database layer (models, ORM)	dev	Normal	wontfix		Mariusz Felisiak	Unreviewed	0	0	0	0	0	0