If you ever have detail questions on what can be done in the API googling PostgREST and your need or going to it's github or postgrest.org can usually get you an answer: Googling postgrest and distinct got these hits: https://github.com/supabase/postgrest-js/issues/206 https://github.com/PostgREST/postgrest/issues/915#issuecomment-1002232582 PostgREST has been hesitant to add a bunch of detail SQL because of performance and security concerns, including denial attacks.