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

Supabase

When querying with a foreign key a object is returned, how do i change it so it become key-value

Can I edit the query so it returns users: { name 'Johnnny boy' } to something like users: 'Johnny Boy' instead?

I don't think you can, maybe u can write a postgresql function to do this

My solution right now is to handle it on the server, modify the response. But thought it would be nifty if it was possible to flatten it when writing the query