I think there’s a feature request in here. I’ve had the same experience using data explorer queries to moderate this community. I like the idea of having query results PM’ed to me on a weekly basis via automation so I can work through them and then have a record of how I am whittling away at a long todo list, but then the results from the exact same query are more interactive via the data explorer UI.
Why can’t the UI be the same in both places?