Where

db.selectFrom('users')
  .selectAll()
  .where('first_name', '=', 'Jennifer')
  .where('age', '>', 40)
  .execute()

db.selectFrom('users').selectAll().where('id', 'in', ['1', '2', '3']).execute()

db.selectFrom('users')
  .selectAll()
  .where((eb) =>
    eb.or([
      eb('first_name', '=', 'Jennifer'),
      eb('first_name', '=', 'Sylvester'),
    ]),
  )
  .execute()

let query = db.selectFrom('users').selectAll()
 
if (firstName) {
  query = query.where('first_name', '=', firstName)
}
 
if (lastName) {
  query = query.where('last_name', '=', lastName)
}

db.selectFrom(['users', 'profiles'])
  .selectAll()
  .whereRef('users.profile_id', '=', 'profiles.id')
  .execute()

db.selectFrom('users')
  .selectAll()
  .where(({ and, or, not }) =>
    and([
      or([eb('age', '<', 18), eb('age', '>', 60)]),
      not('is_banned', '=', true),
    ]),
  )
  .execute()