View Entity History

See all versions of an entity over time:

select id, username, email, version, valid_from, valid_to,
       case when valid_to = '9999-12-31 23:59:59'::timestamptz
            then 'current' else 'historical' end as status
from ores.accounts
where username = 'admin'
order by valid_from;

| id | username | email | version | valid_from | valid_to | status |
|----+----------+-------+---------+------------+----------+--------|