pg_graphql icon indicating copy to clipboard operation
pg_graphql copied to clipboard

Published 20 hours ago • verified publisher icon supabase

Support distinct on query

Open bossjapzz opened this issue 2 years ago • 4 comments

Describe the bug Support distinct on query

Expected behavior From hasura Screen Shot 2022-02-21 at 4 02 51 PM

bossjapzz avatar Feb 21 '22 08:02 bossjapzz

this is a capability we'll be looking in to at some point but it is not currently on the roadmap

olirice avatar Feb 21 '22 16:02 olirice

This issue is stale because it has been open for 30 days with no activity.

github-actions[bot] avatar Mar 24 '22 02:03 github-actions[bot]

this is a capability we'll be looking in to at some point but it is not currently on the roadmap

Hey @olirice, do you have updates about the distinct ?

igorbrasileiro avatar Nov 14 '22 11:11 igorbrasileiro

Sure, I have similar concerns about distinct on as the convo about https://github.com/supabase/pg_graphql/issues/193

TL;DR is that distinct on makes for expensive queries that are difficult to index. The concept of distinct on is unusual in the context of an API (its SQL/DB specific). Our goal is to expose a capable but minimal API to your database rather than all the flexibility of SQL. I'm not saying we'll never tackle this, but given that it isn't a slam dunk with ^ philosophy, exploring it is lower priority than some of the other features on the roadmap

olirice avatar Nov 14 '22 14:11 olirice