Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I think it'll be helpful if the docs specify the return object and its contents.
I'm trying to figure out if the URL of a file is returned after uploading to storage, does any one know this? Or I have to use the getPublicUrl method to get the URL of a just completed file ?

No, it doesn't, but after successful upload, you could use same path to call getPublicUrl.