Problem
On https://docs.postgrest.org/en/v14/references/api/url_grammar.html#custom-queries, we say:
More complicated joins than those provided by Resource Embedding.
It's been a while since we've put that and now we support the equivalent of an anti-join (ref) also with empty embed we should be able to support semi-joins.
RIGHT JOINs are not supported.
Solution
Document which types of JOINs are not supported
Problem
On https://docs.postgrest.org/en/v14/references/api/url_grammar.html#custom-queries, we say:
It's been a while since we've put that and now we support the equivalent of an anti-join (ref) also with empty embed we should be able to support semi-joins.
RIGHT JOINs are not supported.
Solution
Document which types of JOINs are not supported