search

supabase / postgrest-js

Isomorphic JavaScript client for PostgREST.
https://supabase.com
MIT License
964 stars 128 forks source link

Types for column name disambiguation #450

Open wyozi opened 11 months ago

wyozi commented 11 months ago

Bug report

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(*)')

albinekb commented 6 months ago

I have been using the patch from #451 for three months now, it's working great! Any chance of getting that merged? It's a bit messy to have to manage the patch. Thanks!