Point-in-Time Query
Get the state of an entity at a specific point in time:
select id, username, email, version from ores.accounts where username = 'admin' and valid_from <= '2025-01-15 12:00:00'::timestamptz and valid_to > '2025-01-15 12:00:00'::timestamptz;