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%'
`