Found a good website on documentation and examples of SQLite (which is default DB for Nostr relay): https://www.sqlitetutorial.net/sqlite-like/
This helps to write queries which can maintain Nostr relays in healthy state.
#nostr #relay #sqlite #howtosetuprelay