Skip to content

Add support of @> operator. #641

@Satont

Description

@Satont

Is your feature request related to a problem? Please describe.

I has an table, what cannot be migrated to normal architecure.
Schema:
image
Currently i can't check does that array contains item from other array, like in sequelize i can:

where: { 
  follows: { [Op.contains]: [128644134] }, 
  service: 'telegram' 
}

Describe the solution you'd like
Add new operator $contains, with @> implementation

Describe alternatives you've considered
Cannot imagine.

Additional context
My english is not quiet good, again what i wants:

i has array in my column, like [123, 321], and i wan't check does [123, 321] contains any item from where query $contains: [321]

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions