Sequelize support for ~ operator with postgres ltree queries

Question

I have a simple postgres ltree query

select * from data_objects WHERE path ~ 'root.*{1}';

I would like to implement this in sequelize, but there is no mapping for the ~ operator.

Is it possible to override the mappings? or do I have to use a raw sql query?

Answer 1

Found the solution:

params.path = {
        $regexp:'root.*{1}'
};

Which translates as

where "path" ~ 'root.*{1}'

I hadn't seen the $regexp operator