postgrest-js icon indicating copy to clipboard operation
postgrest-js copied to clipboard

Types for column name disambiguation

Open wyozi opened this issue 1 year ago • 1 comments

Bug report

  • [x] I confirm this is a bug with Supabase, not with my own application.
  • [x] I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

PostgREST allows disambiguating relationships by using a column name as the target directly (see column name section of https://postgrest.org/en/stable/references/api/resource_embedding.html#embedding-disambiguation). However, select query parser in postgrest-js does not support this yet.

Personally I find column name disambiguation to be the superior method for embeds, so it would be nice to have this

To Reproduce

Use column name instead of foreign key constraint name or relation name as the target, i.e. .select('user:username(*)') instead of .select('user:users(*)')

wyozi avatar Jul 26 '23 09:07 wyozi