[http://phplens.com/adodb/reference.functions.execute.html execute()] in ADOdb and [http://pear.php.net/manual/en/package.database.db.intro-query.php query()] in PEAR::DB can be used instead of prepare() and execute(), if you set a second parameter (data array) and your query uses placeholders.
In PDO [http://de.php.net/pdo-exec exec()] can only do the following:
$count = $dbh->exec("DELETE FROM fruit WHERE colour = 'red'");
what about something like:
$data = array(
'extension' => $extension,
'name' => $name
);
$count = $dbh->exec("INSERT INTO CREDITS (extension, name) VALUES (:extension, :name)", $data);
of course the second parameter is optional. The syntax should fit to bindParam.