Bug#1138783: elpa-org-roam: org-roam needs elpa-emacsql-sqlite but depends on elpa-emacsql

Package: elpa-org-roam
Version: 2.3.1-1
Severity: normal

Hello,

I did an upgrade on testing and rebooted leading me to restart emacs.
on loading org-roam reported an error needing emacsql-sqlite.

I installed elpa-emacsql-sqlite and restarted emacs and that worked.

Right now there's elpa-emacsql and 3 different database specific
packages

elpa-emacsql - high level SQL database frontend for Emacs
elpa-emacsql-mysql - high level SQL database frontend for Emacs
                     (MySQL backend)
elpa-emacsql-psql - high level SQL database frontend for Emacs
                    (PostgreSQL backend)
elpa-emacsql-sqlite - high level SQL database frontend for Emacs
                      (SQLite backend)

I'm guessing emacsql split the database drivers into subpackages
recently, and org-roam should probably depend explicitly on
elpa-emacsql-sqlite in stead of elpa-emacsql.

Thanks,
Diane

-- System Information:
Debian Release: forky/sid
  APT prefers testing
  APT policy: (500, 'testing'), (110, 'unstable'), (100, 'experimental')
Architecture: amd64 (x86_64)

Kernel: Linux 7.0.10+deb14-amd64 (SMP w/22 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages elpa-org-roam depends on:
ii  dh-elpa-helper           2.1.9
ii  elpa-dash                2.20.0+dfsg-1
ii  elpa-emacsql             4.3.6-1
ii  elpa-magit-section       4.5.0-1
ii  elpa-org                 9.8.4+dfsg-1
ii  emacs-common [elpa-org]  1:30.2+1-3
ii  emacsen-common           3.0.8

Versions of packages elpa-org-roam recommends:
ii  emacs               1:30.2+1-3
ii  emacs-pgtk [emacs]  1:30.2+1-3

Versions of packages elpa-org-roam suggests:
ii  org-roam-doc  2.3.1-1

-- no debconf information