I have created a database view and I would like to show the results in a Drupal Page. The view has some pretty complex SQL behind it, so trying to use the Views module isn't possible.
I just want to do
SELECT * FROM VIEW_X and display the results on a page in PHP.
I know how to do this in Drupal 6, but how is it done in Drupal 7?