How do you make manual/one-off log-based queries?

My app engine instances are logging incoming requests and I'd like to be able to run manual/one-off queries for data analysis. As an example, I would like to be able to determine how many requests are made to each end-point, within a given period. So an SQL query might look something like this: SELECT path, count(path) FROM request_log WHERE time >= :start_time AND time <= :end_time GROUP BY path What is the simplest and most cost effective way to achieve these kinds of queries based on logging data? *Note: Monthly log ingestion is just under 1TB.*