libSQL/SQLite: Issue with CAST and ILIKE

.where(
        or(
          ilike(customers.name, `%${query}%`),
          ilike(customers.email, `%${query}%`),
          sql`CAST(invoices.amount AS TEXT) ILIKE ${`%${query}%`}`,
          sql`CAST(invoices.date AS TEXT) ILIKE ${`%${query}%`}`,
          ilike(invoices.status, `%${query}%`),
        ),
      )