HubSpot EmailEvents API where clause

HubSpot EmailEvents API where clause

Thank you.  I can work with that.  One other question.  
I changed my Query to this and it comes back quickly:
 SELECT t.*
  FROM EmailEvents AS t
 where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' ) 

But, if I add one more filter condition below, the Query runs slow again.  Is this another limit I am hitting up against?
 SELECT t.*
  FROM EmailEvents AS t
 where (t.CreatedAt > '2024-06-10 12:13:00' and t.type = 'SENT' and t.AppName = 'Batch') 

---
Hi,

I am trying to pull data from the HubSpot EmailEvents API.  If I query to pull all data, it works fine.  But if I include a WHERE clause, it seems to just run forever.
SELECT t.*
  FROM EmailEvents AS t
 where (date(t.CreatedAt) > date('now', 'localtime', '-2 day'))

Is it possible to use a WHERE clause with the EmailEvents API?

The HubSpot documentation does show another API for bulk event data transfer, does SkyVia support this API?  see https://legacydocs.hubspot.com/docs/methods/email/get_events

thank you