expr-helper.ts

import { expr } from '@mikro-orm/core';

const res1 = await em.find(Book, {
  // the type argument is optional, use it to get autocomplete on the entity properties
  [expr<Book>(['price', 'createdAt'])]: { $lte: [100, new Date()] },
});

// will issue query similar to this:
// select `b0`.* from `book` as `b0` where (`b0`.`price`, `b0`.`created_at`) <= (?, ?)

const res2 = await em.find(Book, {
  // the type argument is optional, use it to get autocomplete on the entity properties
  [expr(as => `lower(${as}.name)`)]: 'jon',
});

// will issue query similar to this:
// select `b0`.* from `book` as `b0` where lower(b0.name) = ?