---
title: "PostgREST 11 pre-release"
description: "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."
---

# PostgREST 11 pre-release

[Supabase](https://yomu.fyi/company/supabase) · steve\_chavez · Dec 16, 2022

**Type:** Announcement

## 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.

## Context

PostgREST 11 is not yet complete, but a pre-release containing the latest features and fixes is available through the Supabase CLI. It is not deployed to Supabase Cloud.

## Approach / What changed

The release adds spread operators for flattening columns from related one-to-one and many-to-one tables, ordering by related-table columns, and filtering related resources with is.null or not.is.null to express anti-joins and inner-join behavior.

## Takeaways

- 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.
- Queries can order rows by a column in a related one-to-one or many-to-one table, such as technical\_specs.duration.
- 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.

**Tags:** [Postgres](https://yomu.fyi/topic/postgres), [REST APIs](https://yomu.fyi/topic/rest-api)

- Source: [Supabase](https://supabase.com/blog/postgrest-11-prerelease)
- Source URL: https://supabase.com/blog/postgrest-11-prerelease
- Ingested by Yomu: 2026-08-29T01:15:43.512Z

[Read original post](https://supabase.com/blog/postgrest-11-prerelease)