I have two tables that are indirectly related with the same foreign key from a third table. Something like the image. Trying to join the post and follow tables with supabase API. Something like

select *
from post
inner join follow post.com_id = follow.com_id

My attemps is:

_client
          .from(post)
          .select("*, $follow!inner(com_id)")
          .eq("$follow.user_id", uid)
          .order(createdAtField, ascending: false)
          .limit(3)
          .execute();

But I get an error that there is no relation between follow and post. But should this not just be a normal join? Or do someone know how to join these? Thanks 🙂