Typeorm filter columns that have been transformed

Question

I used the typeorm-Encrypted, to encrypt columns containing sensitive application data via the parameter Transformer as shown below:

    @PrimaryColumn()
    protocolo: number;

    @Column({
        nullable: false,
        transformer: CryptoTransformer,
    })
    nome: string;

    @Column({
        name: 'titular_nome',
        nullable: false,
        transformer: CryptoTransformer,
    })
    titularNome: string;

Content of Cryptotransformer:

import { EncryptionTransformer } from "typeorm-encrypted";
import dotenv from 'dotenv';

dotenv.config();

export default new EncryptionTransformer({
    key: `${process.env.DB_KEY}`,
    algorithm: 'aes-256-cbc',
    ivLength: 16,
    iv: `${process.env.DB_IV}`,
});

I would like to apply filters to these columns, and I’m trying to do this using the method Repository.createQueryBuilder() of Typeorm, as shown below:

const builder = repository.createQueryBuilder('em');
const nomeTeste = "maria";

builder.andWhere('LOWER(em.nome) LIKE LOWER(:nome) OR LOWER(em.titularNome) LIKE LOWER(:nome)', { nome: `%${nomeTeste}%` });

However, although there are records in the database that meet the query filters, nothing is returned, because the database value is encrypted and there is no "maria" substring in the encrypted columns.

I thought about encrypting the filters before performing the query, but I don’t think this is the smartest solution, besides probably filters that use the "LIKE" operator wouldn’t work to compare encrypted values.

Could you help me find a solution to apply filters to these cryptographic columns?