Casting JSON fields in where clause

[tmont]

I can't really figure if this is supported or not. I'm basically trying to query by equality on a boolean value inside a JSON object:

MyModel.findAll({
  where: {
    someJsonColumn: {
      someProperty: {
        $eq: true
      }
    }
  }
})

This throws a noperator does not exist: text = boolean error. Basically the query needs a ::boolean cast at the end of it, and I'm not totally sure if that's even possible in Sequelize.

As a workaround, I can just change true to 'true', but I'd rather not do that if I don't have to.

[janmeier]

I think I talked with @mickhansen about this previously, and we'd really like this to be transparent for the user, so the value is casted automagically.

[mahnunchik]

Hi @janmeier @mickhansen how to cast values in JSON?

Related: #11998