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

Supabase

crossposing from <#843999948717555735> here since it might fit better;

I'm trying to make a RLS policy where anyone can get rows from a table but only specific information is returned, here's what i have so far but its giving me a syntax error:
```sql
CREATE POLICY "Public profiles with minimal data"
ON public.profiles
FOR SELECT USING (
  SELECT id, preferred_name, identity_data - 'email' identity_data, access FROM public.profiles 
);
```

i'm not sure if policies are supposed to be used for this. u can select specific columns with the api or create a view

yeah I ended up just using the server side for it

RLS policies can only restrict access to rows. Ordinary permissions can restrict access to columns. For anything inbetween you'll need a custom function.