I don't think so. I've tried simpler query in mysql console client:
SELECT * FROM (DESCRIBE [table_name]) AS [alias]
and it failed. Theoreticaly it should work but it failed, so I think that your query will also fail.
I haven't thought about such queries before. After reading your post I thought that such queries are possible. When you type "DESCRIBE [table_name]" in console client you will see the result as text table, with columns and fields, as usually when you type "SELECT ..." query, so I thought it's possible.