I’m working with a JSON string in PostgreSQL, and I’m trying to extract the id property from a nested JSON object. However, I’m struggling to get the desired result, and the query keeps returning null.

I’m working with a JSON string in PostgreSQL, and I’m trying to extract the id property from a nested JSON object. However, I’m struggling to get the desired result, and the query keeps returning null.

I created enum in Supabase with name “role” and contains “owner” and “employee” value like this: