I'd like to convert the instructions from this answer into a general script that can be reused across projects.
I'm wondering how these commands can be written in Drupal 7 PDO format:
UPDATE `system` SET filename = replace(filename, 'sites/all/modules/contrib', 'profiles/distroname/modules/contrib');
What are the advantages of writing it PDO, as opposed to just a simple
db_query() with the sql query from above? In PDO, will this truly be db agnostic?