"Clean" RHEL comes without a perl installation these days (it was also true for RHEL 8, and still is for RHEL 9).
When MariaDB RPMs are installed, they pull a bunch of perl-xxx packages as a dependency. It includes perl-interpreter which contains perl binary, but doesn't include perl metapackage as such.

In RHEL-8, it seems to be enough.
In RHEL-9, lib.pm has been moved from perl-interpreter into a separate package perl-lib (not to be confused with perl-libs, which contains a lot of stuff).
perl-lib can be installed by itself or as a dependency of the perl metapackage. However, perl-interpreter and other perl-xxx packages which are installed along with MariaDB do not pull it.

It is needed for MTR at least. So, I suppose either perl-lib or perl need to be made a dependency.

Also, a bunch of packages like perl-File-Find, perl-Time etc. are not installed while also needed for MTR (and maybe not only for MTR). All in all, it seems simpler to add a dependency on perl metapackage rather than all subpackages individually.

I only checked 10.6, but I don't expect there is a difference for other versions.