PostgREST 13

PostgREST 13 introduces significant API and observability enhancements, notably allowing one-to-many and many-to-many relationships to be represented as flat JSON arrays, which can simplify the creation of hierarchical JSON structures for front-end applications. The update also includes automatic conversion of text and JSON/JSONB columns to tsvector for full-text search capabilities and the addition of headers like Max Affected Content-Length and Proxy-Status to enhance observability by tracking request sizes and error codes. Breaking changes include stricter JWT and JWKS validation requirements and schema validation, ensuring that non-existent schemas cannot be used, which prevents errors during migrations. Users can upgrade to PostgREST v13 on the Supabase platform to access these new features and improvements, with further details available in the official documentation and release notes.