Our Drupal site is to leverage data from a second MySQL database. The conneciton is already in place in settings.php
I'm wondering now if there is a module I can use to interact with it (select, update, etc). Or at least what's the best practice working with SQL queries - GUI with a module, or code?
One goal is to display the results on screen, and allow the User to filter rows and columns.