Is it possible to hash a column?

[greeksolid]

I am currently using Prisma and I am using this middleware (https://github.com/47ng/prisma-field-encryption) to hash a Postgres column.
The Prisma model looks something like this, and I am able to query the database when users submit the plain text credit value.

model Credit {
  credit         String      @unique @db.Text /// @encrypted
  creditHash     String?     @unique @db.Text /// @encryption:hash(credit)
}

// the middleware compares the value automagically and this returns a result
const result = await ctx.prisma.credit.findUnique({
  where: {
    credit: "ABC-123"
  }
});

In drizzle I tried to do it with the following code unsuccessfully. Or maybe it is possible to achieve the same functionality with pgcrypto somehow?
Any recommendations?

// insert that seems to work
await drizzle.insert(exam).values({
  credit: sql`sha256(${credit})`,
});

// query that fails
const inputCredit = "ABC-123";
const result = await drizzle.query.credit.findMany({
  where: eq(credit.credit, sql.raw(`encode(sha256(${inputCredit }), 'hex')`)),
});