JSON field filtering

Hello everyone,
I have a quick question:
Is it possible to filter items in collection based of value inside json field?
In example we have a collection called “product”. Each product have field called “address” (JSON string) with the fallowing structure:

{
 "city": string
 "country": {
  "name": string
  "code": string
 }
}

What i would like to do (ideally without having to wright SQL queries) is to be able to filter products based of in example city name or the code of an country.
Any suggestions are welcome!
Thanks guys!!

This topic has been created from a Discord post (1303062311677726810) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord