Text search on a JSON field

Hi everyone,

is it possible with only a Query All Records to find all the rows where a JSON field contains a search text value, either in a key or in a value?

ie, i have 3 rows where the JSON field values are:

Row 1:

{
  "first": "premier"
}

Row 2:

{
  "three": "better than four or 4",
  "maison": "guillaume"
}

Row 3:

{
  "count": "up to four no more no less",
  "city": "Paris"
}

i'd like to be able to search for all the rows that contain "four".

If i'm not mistaken actually, through a Query All Records, it's not possible. I have to do a Query All Records without constraints on JSON field, then use filters and/or lambdas to find the items i'm looking for.