PostgREST 11 pre-release

Summary

PostgREST 11 is still in pre-release, with the latest features and fixes available through the Supabase CLI rather than Supabase Cloud. The update improves querying related data with spread operators that flatten one-to-one and many-to-one relationships into the response, avoiding an extra view or function for that shape. Related-table ordering is also supported, such as ordering films by technical_specs.duration, with the same relationship limitation. Anti-joins and inner-join behavior can be expressed by filtering related resources with is.null or not.is.null; the latter can also be combined with an or filter and is more flexible than the existing !inner modifier. The release can be tried locally with supabase start, and the post asks users to report bugs, suggestions, and ideas.

Takeaways

1. 1

   Spread operators flatten selected columns from one-to-one and many-to-one related tables, removing the nested related-table object from the response without requiring a new view or function.

2. 2

   Queries can order rows by a column in a related one-to-one or many-to-one table, such as technical_specs.duration.

3. 3

   Filtering a related resource with not.is.null is more flexible than the existing !inner modifier because it can be combined with an or filter; is.null provides the equivalent of a left anti-join.