I was able to get org-roam
working with the following procedure:
Install emacsql-sqlite
through Nix. (Installing org-roam
this way wouldn’t help much because that’s not the one with native C code.)
Then you need to indicate to Doom Emacs that you prefer the copy of emacsql-sqlite
installed outside of Doom: