How do I write a simple join for these tables in v2

profiles
  user_id (pk)
  username 
  avatar_url

posts
  post_id (pk)
  user_id
  title
  description

let { data: posts, error } = await supabase
    .from('posts')
    .select('*, profiles(*)')