Provide an automatic way to access slave's Information schema.slave_status table from the master

Since the implementation of https://jira.mariadb.org/browse/MDEV-33526 we have a way to query slave status details from the information_schema table on slave itself. In some cases it would be useful to have a way to get this information with SELECT from the master as well, for each active connected slave (binlog dump thread).

Thoretically one can create a Spider (or CONNECT) table in some schema on master pointing out to the information_schema.slave_status on slave and then use it. This feature request is for some way to do this automatically for any new row in the output of SHOW SLAVE HOSTS, with a name based on some pattern based on slave's server_id.