Nice. This was on my todo list for org-roam v2. For future reference, midas said org-expiry auto stamps creation time.
I chose a filebased approach over an extension to the db structure because the org-roam db is somewhat ephemeral, in that you should be able to regenerate the complete db from the files at any point in time.
I think placing in database is useful for sorting and filtering as I do so in org roam search.