Add support for querying latest ingested event timestamp

Add support for querying latest ingested event raw timestamp.
Useful for the knowing how much updated information realtime pipeline has specifically with high rollup granularity.
I agree, a separate implementation of IngestMetadataQuery would be more cleaner approach, 
closing this PR, will open a new one.