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

Supabase

Is it common and efficient to store json or jsonb data in columns?

Yes it is efficient to store json data in jsonb column with Postgres, just don't overdo it and store huge json data.

Do remember its not a document database, so try and normalise your data as much as possible by creating columns instead of just creating one jsonb column to store all the things.