GraphQL is now available in Supabase

Supabase has introduced significant enhancements to its pg_graphql extension, which enables querying PostgreSQL databases using GraphQL from SQL or over HTTP. The update includes schema reflection, where tables become types and columns become fields, as well as support for bulk CRUD operations with pagination, filters, and ordering. Security features include authentication based on PostgreSQL's built-in primitives and authorization that respects existing row level security policies. Performance optimizations include transpiling GraphQL queries into a single SQL query and caching prepared statements to reduce network round-trips and time spent in the database. To enable GraphQL in Supabase, users can create the extension in their database or enable it from the dashboard.