It would be great if we could use join on a supabase query.
You can circumvent this issue by creating a database view, but I don't want to create a view for every single join statement.
Since supabase/firebase doesn't recommend you to change the auth users table, this is a very common problem. As soon as you try to get any extra info about a user you need to use a join query.