min

The min method will pluck a field with the lowest value

const id = await User.min('id')

select min("id") from "users"

min is smart enough to know the return type for id, so the returned value will already have the correct type cast for the id field.

Chaining

You can leverage chainable methods to filter out records at the sql level before calling min.

const id = await User.where({ email: ops.ilike('%burpcollaborator%') }).min(
  'id',
)

select min("id") from "users" where ("users"."email" ilike $1)