Supabase helper for better RPC function typing with jsonb fields

The problem

When you have those tables used for say vector search... you usually have a jsonb field for metadata like this:

create table
  documents (
    id text not null,
    vector extensions.vector null,
    content text not null,
     ---v--- this field
    metadata jsonb null, 
    constraint documents_pkey primary key (id)
  )

Where let's say you always have this in your jsonb metadata

 type Metadata = { 
    sourceUrl: string
    otherField: string
 }

But when you do a supabase call say supabase.rpc('match_vec_doc', args)... even …

create documents extensions fields function key llm metadata null rpc search supabase table tables text typescript typing vector vectordatabase vector search