Jsquery is PostgreSQL extension, which provides advanced query language for jsonb documents.

Features:

• recursive structure of query
• search in array
• rich set of comparison operators
• types support
• schema support (constraints on keys, values)
• indexes support
• hinting support

Jsquery implemented as datatype jsquery and operator @@.

Examples:

# - any element array

SELECT '{"a": {"b": [1,2,3]}}'::jsonb @@ 'a.b.# = 2';

% - any key

SELECT '{"a": {"b": [1,2,3]}}'::jsonb @@ '%.b.# = 2';

* - anything

SELECT '{"a": {"b": [1,2,3]}}'::jsonb @@ '*.# = 2';

$ - current element

select '{"a": {"b": [1,2,3]}}'::jsonb @@ 'a.b.# ($ = 2 OR $ < 3)';

Use "double quotes" for key !

select 'a1."12222" < 111'::jsquery;

• Syntax
• Indexes
• Optimizer

Requirements:

• PostgreSQL >= 9.4

git clone https://github.com/akorotkov/jsquery.git $SOURCE_DIR/contrib
cd $SOURCE_DIR/contrib/jsquery && make && make install && make installcheck

# or not from pg sources

git clone https://github.com/akorotkov/jsquery.git
cd jsquery && make USE_PGXS=1 && make install USE_PGXS=1

TODO

• Implement jsquery as extension of SQL syntax

You can contribute by:

• stars
• issues
• documentation
• pull requests

• Oleg Bartunov
• Teodor Sigaev
• Alexand Korotkov

Development is sponsored by [Wargaming.net]

GPL