[typeOrm]Rawクエリの使用例

// already there
 
 querybuilder
  .[...]
  .where('LOWER(users.email) = :email', { email: email.toLowerCase() });

// unsafe via repository, since params are unescaped:
repo.findOne({
  where: {
    email: Raw(alias => `LOWER(${alias}) = '${email.toLowerCase()}'`).
  },
});

// would be nice to have:
repo.findOne({
  where: {
    email: Raw(alias => 'LOWER(${alias}) = :email', { email: email.toLowerCase() }),
  },
});

const [result, total] = await this.findAndCount(
    {
  where: { title: Raw(alias => `LOWER(${alias}) Like '%${value}%'`) },

take: take,
  skip: skip
}

);
  return {
    data: result,
    count: total
  }