PostgREST 9

PostgREST 9, released on November 27th, introduces new features such as resource embedding with inner joins and functions with unnamed parameters. Inner join capabilities allow for filtering rows of the top-level table based on a filter of an embedded table. Functions with unnamed parameters enable POST requests to functions with a single parameter, useful for webhooks that send JSON payloads. Additionally, PostgREST 9 is compatible with PostgreSQL 14 and includes support for partitioned tables, improved documentation, and bug fixes.