As I understand it, org-roam uses the database as an information cache to improve performance. But the org roam files are self-contained and doesn't need the database to be saved along with it.
I recall seeing some discussion on emacs-devel about SQLite being bundled with Emacs too. If that came to pass then it's no longer a true external dependency either.
