title: PostgreSQL query to Supabase Query
body: <p>How can i make once of this PostgreSQL querys in supabase?
  I tried reading supabase doc but it doesn't work</p>
  <pre><code>select rooms.id as room_id, members.id as member_id, user_id from rooms 
  inner join members 
  on rooms.id = members.room_id 
  where rooms.id = members.room_id
  
  and user_id = 1
  </code></pre>
  <p>Or</p>
  <pre><code>select room_id, user_id, members.id from members 
  inner join rooms 
  on rooms.id = members.room_id 
  where members.user_id = 1
  </code></pre>