ezidam/crates/database/queries/keys/get_all_revoked.sql

select id,
       created_at as "created_at: DateTime<Utc>",
       revoked_at as "revoked_at: DateTime<Utc>",
       private_der,
       public_der

from keys
where revoked_at is not null
order by created_at desc