Text/HTML module doesn't accept data injected from an SQL query. However, there are many modules which can do this in various ways.

If you want to display data in a tabular format, take a look at www.tressleworks.com SGSV aka SQL Grid Selected View. It has some very powerful features.

Similarly, you can pull and display data using Enterprise forms even though not as a form per se; it can perform as a sort of content management tool.

Another flexible and popular module is XMod.

These are all third party modules. You might want also to look at the DNN core module called, I believe, Reports. I haven't looked at it closely but it might be able to do this kind of thing.

Hope this is helpful -