The query will not look like that. PostgREST will write a CTE query for most of these. The syntax you have from the SDK isn't directly related to SQL, it's a Rest API url builder. If you want to see the query you can look in your Postgres logs inside the Supabase dashboard. Supabase also has a tool for converting SQL to the REST API https://supabase.com/docs/guides/api/sql-to-rest, however they don't have a tool that does the opposite.