max

The max method will pluck a field with the highest value.

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

select max("id") from "users"

max 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 max.

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

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