@AaronGutiCompletely agree. At this point warehousing data is completely futile with out the ability to search for archived records since a date. The only available option is to do periodic FULL syncs of all non-archived records to see which ones should not be in the DB (or tagged as archived).
We have used two different tools to sync data from HubSpot and both have this issue (Segment and Airbyte).