anyone really good at kysely that could help me with a query? will tip degen 😜

bringing onchain communities together • events.xyz (@event)

idk about really good but i've used it quite a bit, whatsup?

I like building apps on web3 protocols. DevRel @ ENS Labs. gregskril.com

kysely
      .selectFrom("casts")
      .select(["fid", "text", "timestamp"])
      .where("embeds->0->>url", "like", `%${params.id.slice(0, 8)}%`)
      .orderBy("timestamp", "desc")
      .limit(100)
      .execute()

the "embeds->0->>url" is what's throwing the error in my linter

I'm using neynar's db access to grab all casts that mention an event. The cast table has an embeds column (a json array of objects with the key "url).

But the following query is failing. I'm not sure how to do a like operation with in a nested array. Can't upload images so it's in the next cast. Any ideas?