Get Account by UUID

select id, username, email, version, valid_from
from ores.accounts
where id = 'your-uuid-here'
  and valid_to = '9999-12-31 23:59:59'::timestamptz;