Is it possible to search by an occurrence in a Django JSONField?

Question

PostgreSQL

Good day! I work with semi-structured data. I use the classic EAV model. But there is no limit to perfection. Found time to try replacing EAV with jsonb in postgresql. I stumbled on the fact that I can’t figure out how to implement a search for an occurrence in a string. Is it possible? If so, how? A Django or pure SQL solution will do. To make it clearer, an example: there is a model

class SomeModel(models.Model):
    data = JSONField()

json is stored in the data field (2 rows in the database table):

{"name": "Michael", "friend_name": "Sara"}
{"name": "Miranda", "friend_name": "Richard"}

The search implies that when you enter "ar" it will return both strings ("ar" in "Sara", "ar" in "Miranda"), "cha" - again two strings ("cha" in "Michael", "ar" in "Richard"), "ir" - only one ("ir" in "Miranda"), "asdq" - none. Is it possible to implement this in Django? Is it possible to implement using SQL?

Answer 1

Any _normal_ solution will put shinxsearch and shamanize Clumsy
- we take the whole dict and glue it into a string with spaces and look for it like