Loading the data via foreign key in Supabase

Hey Folks,

I hope you are getting prepared to submit your work. Good luck with that!

I’m interested how I could get data via foreign key in supabase. For example, I have a Posts table with UserId of an user that creates the post. I’d like to get the user’s name from Users database with UserId. Is that possible? Without getting the whole list of Users and filtering via UserId it will kill the performance I believe.

Thanks 🙏🏻