Archive me, trying to contribute to org-roam and Free Software.
These days, this code is implemented in my fork of org-roam since upstream wasn't interested in the change. It's implemented in a mess of changes but org-roam-keywords shows the keyword caching logic, and you can look for org-roam-db--insert-extras in org-roam-db.