Home / Companies / Supabase / Blog / Post Details
Content Deep Dive

PostgREST 11 pre-release

Blog post from Supabase

Post Details
Company
Date Published
Author
Steve Chavez
Word Count
630
Language
English
Hacker News Points
-
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.