Company
Date Published
Author
Steve Chavez
Word count
630
Language
English
Hacker News points
None

Summary

PostgREST 11 introduces improved querying capabilities, including spreading related tables, related orders, and anti-joins. Spreading related tables allows for a "flattened" result to be presented to the frontend without nested objects. Order by related tables enables ordering of a table based on a related table column. Anti-joins allow filtering rows where the related table is null or not null, providing more flexibility in combining related tables' conditions. These features are currently available as a pre-release and can be tried out locally with the Supabase CLI.