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
36139	Allow expressing JSONObject keys dynamically, as well as explicit pair-values	john-parton	john-parton	"Currently there is no way to build a JSON object in the database using the JSONObject function where the keys are anything but static keys.

This is not a limitation of any of the backends that support JSON objects.

If you could specify the items of a JSONObject positionally, you get the benefit of being able to construct objects with non-static keys. 

As an example esoteric usage, if you're trying to get the database to emit valid objects for the Elasticsearch DSL, you would almost certainly need to be able to build objects with non-static keys.

For example https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-term-query.html

The key ""user.id"" refers to a field in elastic.

See some discussion here: https://github.com/django/django/pull/19097#issuecomment-2611270246

I'll throw together a patch."	New feature	closed	Database layer (models, ORM)	dev	Normal	wontfix			Unreviewed	1	0	0	0	0	0