Executes a command for a given transaction specified with pid. If the execution fails, it will be caught in Query.transaction/1 and reported back using {:error, err}.