Query: find transactions which weren't broadcasted before being mined
Given a block hash, which transactions appear to have been added by the miner? Transactions which were first heard over the P2P network are added to node_transaction, and after being confirmed in a block, they are moved to node_transaction_history.
If the Chaingraph instance has been running for at least the past block, any transactions which were sent over the P2P network should be present in node_transaction_history; any transactions in the following block which are not present can be assumed to have been added directly by the miner without broadcasting them over the network.
This would be a good example query to add to the website, and possibly would make a good computed field, e.g. block.unbroadcasted_transactions.