Can't use pgroonga extension in drizzle?

[acee90]

I'm using supabase + drizzle ORM, and I'm trying to do full-text search using pgroonga.

// this is work
db.select()
      .from(posts)
      .where(sql`extract_text_from_json(${posts.contentJson}) &@~ ${'abc'}`)

// this is not work
  db.select()
      .from(posts)
      .where(sql`extract_text_from_json(${posts.contentJson}) &@~ ${'abc'}`)

When I excute the second query, I get the following error:

 ⨯ [Error [PostgresError]: operator does not exist: text &@~ unknown] {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42883',
  hint: 'No operator matches the given name and argument types. You might need to add explicit type casts.',
  position: '231',
  file: 'parse_oper.c',
  line: '647',
  routine: 'op_error',
  digest: '3413031381'
}

Can't I use pgroonga in drizzleORM?
Besides installing the pgroonga extension in supabase, do I need to configure something in drizzle?

[margaretjoanmiller]

Wondering this as well! I don't want to add yet another service to my stack and would rather just keep it all in postgres