Creating a Partial Index - How to pass where predicate at table.index method

[brkn]

I'm trying to add a partial index. It's mentioned at knex docs here

In PostgreSQL (....) a partial index can be specified by setting a 'where' predicate.

Their example is like this:

knex.table('users', function (table) {
  table.index(['name', 'last_name'], 'idx_name_last_name', {
    predicate: knex.whereNotNull('email'),
  });
});

But this is not documented at adonisjs docs site. How do I pass a where predicate to create a partial index.

What I've tried

this.schema.alterTable(this.tableName, (table) => {
  table.index('book_id', undefined, {
    predicate: {
      where: this.db.from(this.tableName).where('is_listed', true),
    },
  })
})

Gives type error: Type 'DatabaseQueryBuilderContract' is not assignable to type 'Where<any, any>'

[brkn]

Moved to adonisjs/lucid#832