DROP PROCEDURE IF EXISTS `_`.`materialize_sql`;

DELIMITER ||

CREATE PROCEDURE `_`.`materialize_sql`(IN p_name VARCHAR(56), IN p_sql TEXT)

	MODIFIES SQL DATA

BEGIN

	# SET p_name := CONCAT('`', REPLACE(p_name, '`', '``'), '`');

	-- create table

	SET @v_materialized_sql := CONCAT_WS('',

		  'CREATE OR REPLACE TEMPORARY TABLE `_`.', p_name

		, ' ENGINE = CONNECT'

		, ' TABLE_TYPE = MYSQL'

		, ' SRCDEF = ''', REPLACE(p_sql, '''', ''''''), ''''

		, ' CONNECTION = ''_'''

		);

	PREPARE stmt_materialized_sql FROM @v_materialized_sql;

	EXECUTE stmt_materialized_sql;

END ||

DELIMITER ;

CALL materialize_sql('x', 'SHOW MASTER STATUS');

DESC x;

SELECT * FROM x;