Might be a silly question but is it possible to create a content type or a node type (excuse terminology errors) that can have say php code that will query the database and display results?

I'm thinking along the lines of creating reports to display database data of whatever description..

TIA