Hi, can someone please help me turn this query into a supabase-js query ?
select *
from profiles
INNER JOIN images ON profiles.id = images.profile_id
INNER JOIN follows on profiles.id = follows.following_id
where follower_id = 12;This works:
let { data: images } = await supabase
.from('images')
.select('*, profiles!inner(*)')
.range(0, 25)
.eq('profiles.id', 10)
.order('created_at', { ascending: false });But can't figure out the syntax to add follows.following_id. It is a FK to profiles but it's a composite key with followers_id. For some reason can't get a working version of this SQL query into Javascript.
