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
35718	Some useful postgres functions for JSON are missing from contrib	john-parton		"There's a large number of postgres-specific functions for manipulating json: https://www.postgresql.org/docs/current/functions-json.html

In my projects for work, I have created several:

* jsonb_build_object
* jsonb_build_array
* jsonb_array_elements
* jsonb_extract_path
* jsonb_extract_path_text
* jsonb_array_length

It would be nice if these were included in `contrib.postgres.functions`, ideally in a submodule like `contrib.postgres.function.json` to allow room to expand.

I know postgres's json support is a bit of test-bed for more fleshed out json support in general, but I would recommend just adding things as postgres-specific to limit the scope of the changes.

I can open a basic pull request."	New feature	new	contrib.postgres	dev	Normal				Unreviewed	0	0	0	0	0	0