postgrest-js
postgrest-js copied to clipboard
Types for column name disambiguation
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(*)')
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!