In supabase-js how to display corresponding SQL query in console.log?

Question

I want this

const { data, error } = await supabase
        .from('users')
        .select(`*`)
        .eq('id', 5)
        .single();

to print out this

SELECT * FROM users WHERE id=5

in console.

or atleast where can i find it in the supabase dashboard logs

Andrew Smith · Accepted Answer · 2024-11-03 23:05:44Z

2

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.

answered Nov 3, 2024 at 23:05

Andrew Smith

1,98611 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

In supabase-js how to display corresponding SQL query in console.log?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related