best farcaster developers build on neynar.com | /neynar

We're working on some fixes with @neynar, but for now if you're using the verifications table then use this to parse out the address: 

from_hex(COALESCE(try(split(claim, '"')[4]), try(split(claim, '''')[4])))

for mentions col in casts, use:

split(replace(replace(replace(cancel.mentions,'[',''),']',''),' ',''),',')

headmaster @duneanalytics, previously mirror and consensys

note that these will break after the fix and you'll need to edit it back to the normal json_value and array[] logic. so don't delete your old logic, just comment it out for now.

I know it's ugly. We'll have a fix out hopefully by Friday.