I was joking about filters: { sql } nostr subscriptions.

If you run your own relay, you could make it support filters: { searchTerm } and do a nip for it. Rest api may be easier though.