Querying Supabase JSON Columns Fails

1. Using = instead of -> operator for JSON access
2. Not using ->> to get text value
3. Missing quotes around JSON keys
4. Supabase query API doesn't support JSONB operators
5. Type mismatch (comparing string to JSON)

Use correct operators in SQL:

-- Get nested value (returns JSON)
SELECT data->'user'->>'name' FROM items;

-- Query with WHERE
SELECT * FROM items WHERE data->'user'->>'name' = 'John';

-- With contains operator
SELECT * FROM items WHERE data @> '{"status": "active"}';

For Supabase client, use contains filter.