[alkonaut]

Can't most db systems just create a view over the data where archived_at is null, and this view is the table you use for 99% of your business needs (except auditing, undelete, ...)?

[arethuza]

I'd go for two views - one, as you describe, that gives you the "active" records and another that gives you the "inactive" records.