how to process api url query string with a dot (.)

Question

I have a database table, one of my columns stores json.The json is like this

{
    "attributes": {
      "sample": {
        "sample": {
          "sample": "false",
          "sample": "sample"
        }
      },
      "blue": {
        "working": "true"
      }
    },
    "name": "sample"
  },

How can I process this endpoint localhost:500/search?attributes.blue.working=true to get me list of only blue items that are working. I am using python and flask with sqlalchemy

For now I hardcoded possible queries, I am looking for a more suitable approach