Posting here before adding a feature request in github - is there an attempt to support Relative Time/ Time Shift options per Query? As it stands, it is a single setting for all queries. In this example, it would be useful to see firewall logs compared to the same logs the previous hour, all within the same Graph panel. However, the Relative time/ Time shift options are global for all of the queries.
The Meta Queries plugin supports some aspects of this, but it has some shortcomings that would be solved if this was built into Grafana per Query.