exists

The exists method will return true if at least one record is found matching the query. Otherwise, it will return false.

const exists = await User.exists()

select "users".* from "users"
inner join "pets" on "users"."id" = "pets"."user_id"
limit $1

Chaining

Similar to other execution methods, exists can be chained together with other query building methods prior to execution.

const exists = await User.innerJoin('pets', { name: 'I liked it' }).exists()

select "users".* from "users"
inner join "pets" on "users"."id" = "pets"."user_id"
limit $1