Support nulls=stripped introduced by PostgREST 11.2.0

[steve-chavez]

PostgREST 11.2.0 introduced stripping of null value properties in JSON results for arrays and single object responses. To support that functionality in postgrest-js a method like stripNulls()could be introduced. For instance: client.from('table').select().stripNulls().

Further information:

https://github.com/PostgREST/postgrest/releases/tag/v11.2.0 (see "Resource Representation")
https://postgrest.org/en/stable/references/api/resource_representation.html#stripped-nulls
https://github.com/PostgREST/postgrest/blob/main/test/spec/Feature/Query/NullsStrip.hs

PostgREST/postgrest#1601
PostgREST/postgrest#2894
PostgREST/postgrest#2899

Originally posted by @vrilcode in supabase/supabase#16479

[imageck]

Great addition. Thank you for the continuous improvement and maintenance.

My two cents: I would also like if it could be set as a global option.

[NiklasPor]

If anyone already needs this before we've got a method for this, you can tune your supabase instance to skip nulls for array responses (e.g. for a specific rpc) like this:

export const supabase = createClient(
  URL,
  ANON_KEY,
  {
    global: {
      fetch: (request, init) => {
        // Use any condition here to determine if the requests should skip nulls:
        const shouldStripNulls = request.toString().includes('rpc/your-rpc-call');
        
        if (shouldStripNulls) {
          const headers = new Headers(init?.headers);
          headers.set('Accept', 'application/vnd.pgrst.array+json;nulls=stripped');
          return fetch(request, { ...init, headers });
        }

        return fetch(request, init);
      },
    },
  },
);

I had some requests with lots of optional columns, cut down the response size by ~50% 👍

Docs: https://docs.postgrest.org/en/v12/references/api/resource_representation.html#stripped-nulls