its mostly for my own troubleshooting. main views to use are nostr_events and nostr_users which can be joined by pubkey column (the base nostr table is very hard to use). basic query might be

`select u.name, e.*

from nostr_events e

join nostr_users u on e.pubkey = u.pubkey

where e.kind = 1

and e.content like '%randomstring%'

`