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
29821	Add JSONField for all supported DBs (and move into core).	Vackar Afzal	nobody	"Django has added JSONField for postgres databases. 
Given that Oracle 12 now has native JSON columns, would be nice to expose this in a similar fashion.

I've provided a reference implementation [here https://github.com/Exscientia/oracle-json-field] and made it available via [pip https://pypi.org/project/oracle-json-field/]. It is based heavily on the Postgres implementation.

Note: In the reference implementation I have added a ```.filter_json()``` method whose only purpose is to ensure that table names are aliased - an Oracle requirement for Json queries. If there is a cleaner way to force table names to be aliased then this can be removed, and give 100% feature parity with Django's core query API i.e. just use ```MyModel.objects.filter(...)```

Is this something that you would consider adding to the official Django project. If so please feel free to re-use any of the code from the reference implementation. Additionally I would be happy to create a pull-request if it makes integration easier. 


"	New feature	closed	Database layer (models, ORM)	dev	Normal	duplicate	Oracle Json		Accepted	0	0	0	0	0	0