> select uid from users wehere jsonpath('$.country', address) = 'CH' PostgreSQL does support functional indexes, so you can easily make this use indexes and th

> select uid from users wehere jsonpath('$.country', address) = 'CH' PostgreSQL does support functional indexes, so you can easily make this use indexes and thus be fast enough for real use (it's a bad example - I'd probably put the address into an addresses table, but it's enough to illustrate the point)