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
-
Source URL
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.