Paddle x Supabase - Data Manipulation

I've setup the paddle integration via the wrapper, I can see the three tables in my Supabase, however I'm trying to create a function & trigger in order to extract data from the jsonb payload that paddle passes into its 'paddle.subscription' table. I have run into countless errors trying to do this a variety of ways... what is the recommended method for this, and should this work?