How to extract SQL queries and display search results?

What is the best way to do SQL queries to a drupal database and display the results on a Drupal site? Views module or should I custom make one specific to my needs? Or is there another, possibly simpler and quicker way?