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
33548	Use -> operator to implement KeyTransform on SQLite 3.38+	Sage Abdullah	Anže Pečar	"SQLite added support for `->` and `->>` operators as of version 3.38.0. From the [https://www.sqlite.org/json1.html#jptr docs]:

  Both the `->` and `->>` operators select the same subcomponent of the JSON to their left. The difference is that `->` always returns a JSON representation of that subcomponent and the `->>` operator always returns an SQL representation of that subcomponent. Thus, these operators are subtly different from a two-argument `json_extract()` function call. A call to `json_extract()` with two arguments will return a JSON representation of the subcomponent if and only if the subcomponent is a JSON array or object, and will return an SQL representation of the subcomponent if the subcomponent is a JSON `null`, string, or numeric value.

It would be nice to have this as a cleanup/optimization, e.g. for the workaround introduced in [https://github.com/django/django/pull/14077 this PR]. Still, we need to check whether the SQLite bundled in the user's Python installation supports it though, so we can't just replace the current implementation."	Cleanup/optimization	assigned	Database layer (models, ORM)	dev	Normal		sqlite jsonfield keytransform	bcail rajdesai24 Paolo Melchiorre	Accepted	1	0	0	1	0	0