Historically, Streamkap's snapphotting queries have been generic across our sources. 

We now use specific SQL suitable for PostgreSQL, which improves performance in loading historical data