I don't really have much experience with JSONB beyond insert and select the entire object. Though based on what I've read, you can create an index on JSONB fields -- not sure if that helps. Also, look up

pg_trgm

to see if it helps avoiding algolia... I was just searching and this article came up and looks interesting (it has a section for "GIN Trigram Indexes" using

pg_trgm

on JSONB) : https://dev.to/scalegrid/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql-5d7e