Split pending_confirmations into pending_outgoing_confirmations and pending_incoming_confirmations
For both task_runs and job_runs
This is inherently ambiguous (that's the entire reason for splitting them out) but we can make a best
guess by checking for presence of a transaction.