distinct

The distinct method returns all unique records matching the given distinct field

const users = await User.distinct('name').all()

select distinct on ("users"."name") "users".* from "users"

Chaining

Similar to other execution methods, distinct is chainable to other query-building methods, such as where

const count = await User.innerJoin('pets as p', { name: 'Aster' })
  .distinct('p.name')
  .count()

select count(DISTINCT $1) as "tablecount" from "users"
inner join "pets" as "p" on "users"."id" = "p"."user_id"