Auto-completion of bash for dnf is now too slow, because /usr/share/bash-completion/completions/dnf script needs sqlite to use /var/cache/dnf/packages.db for quick auto-completions. Without sqlite the script must parse repodata files.
For more info, see: https://github.com/rpm-software-management/dnf/pull/1817
dnf package contains /usr/share/bash-completion/completions/dnf script, so why sqlite is not depency of dnf?
RHEL 9 Content Structure and Guidelines state that weak dependencies in BaseOS are allowed, but discouraged.
By using the Recommends weak dependencies especially for packages in @core group (Minimal host installation) or their direct dependencies, the recommended package gets pulled into the installed package set depending on the current configuration of the dnf transaction.
The dnf package Recommends /usr/bin/sqlite3 if bash-completion and python3-dbus if NetworkManager.
If those packages are needed by dnf for correct operation when bash-completion and/or NetworkManager are also installed, Requires should be used.
If /usr/bin/sqlite3 and python3-dbus are essential in minimal host installations, they should be listed in the @core group in the comps file, not pulled in as a weak side-effect of having dnf in @core.
If they are listed primarily for convenience, Suggests might be better option. Or just drop the weak dependency completely.