Hi there. I am new to supabase and i started integrating with my new Next App. I am having a Public table(named X) with auth_id(foreign key connecting with auth users table). I need to retrive the data from both table X and auth users using relation. Anyone can help on it ?

Can you give an example of what you have tried already please?

const { data, error } = await supabase .from('tableX') .select(

*,
    auth.users (
      metaData
    )

)

You can't query

auth.users

directly as it's part of a private schema.

metaData