Database Functions & Triggers in Supabase

-- Create function
CREATE FUNCTION increment_views(post_id INT)
RETURNS void AS $$
BEGIN
  UPDATE posts
  SET views = views + 1
  WHERE id = post_id;
END;
$$ LANGUAGE plpgsql;

-- Call from client
const { data, error } = await supabase
  .rpc('increment_views', { post_id: 123 })