PostgREST 11 pre-release
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.
Company
Supabase
Date published
Dec. 16, 2022
Author(s)
Steve Chavez
Word count
630
Language
English
Hacker News points
None found.