$ cat show-mariadb-pretrans 

#!/bin/sh

ls MariaDB*.rpm

echo

tblfmt='%s\t%s\t%s\t%s\n'

{

    versions=( 10.4.28 10.4.29 10.4.30 )

    printf "${tblfmt}" subpackage "${versions[@]}"

    for n in backup client common compat server shared; do

        z=( )

        for v in "${versions[@]}"; do

            f=MariaDB-$n-$v-1.el8.x86_64.rpm

            z+=( "'$(rpm -q --scripts -p $f 2> /dev/null | grep pretrans)'" )

        done

        printf "${tblfmt}" ${n} "${z[@]}"

    done

} | column -o'    ' -s'	' -t

echo

$ ./show-mariadb-pretrans 

MariaDB-backup-10.4.28-1.el8.x86_64.rpm  MariaDB-common-10.4.28-1.el8.x86_64.rpm  MariaDB-server-10.4.28-1.el8.x86_64.rpm

MariaDB-backup-10.4.29-1.el8.x86_64.rpm  MariaDB-common-10.4.29-1.el8.x86_64.rpm  MariaDB-server-10.4.29-1.el8.x86_64.rpm

MariaDB-backup-10.4.30-1.el8.x86_64.rpm  MariaDB-common-10.4.30-1.el8.x86_64.rpm  MariaDB-server-10.4.30-1.el8.x86_64.rpm

MariaDB-client-10.4.28-1.el8.x86_64.rpm  MariaDB-compat-10.4.28-1.el8.x86_64.rpm  MariaDB-shared-10.4.28-1.el8.x86_64.rpm

MariaDB-client-10.4.29-1.el8.x86_64.rpm  MariaDB-compat-10.4.29-1.el8.x86_64.rpm  MariaDB-shared-10.4.29-1.el8.x86_64.rpm

MariaDB-client-10.4.30-1.el8.x86_64.rpm  MariaDB-compat-10.4.30-1.el8.x86_64.rpm  MariaDB-shared-10.4.30-1.el8.x86_64.rpm

subpackage    10.4.28    10.4.29                        10.4.30

backup        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

client        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

common        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

compat        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

server        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

shared        ''         'pretrans program: /bin/sh'    'pretrans program: /bin/sh'

$