we need to bring to doc:

Some of the mcsadmin commands already have SQL versions (edited)

MariaDB [test]> select mcssystemreadonly();
---------------------

---------------------

---------------------
1 row in set (0.001 sec)

MariaDB [test]> select mcssystemready();
------------------

------------------

------------------
1 row in set (0.001 sec)

Remember the API is just for Cluster Management

MariaDB [(none)]> SELECT * FROM mysql.func where name LIKE 'mcs%';
-----------------------------------------------+

-----------------------------------------------+

-----------------------------------------------+
3 rows in set (0.000 sec)

MariaDB [(none)]> SELECT * FROM mysql.func where dl LIKE 'ha_columnstore%';
---------------------------------------------------------+

---------------------------------------------------------+

---------------------------------------------------------+