I figure the easiest way to ensure they are GOOD is make a list of the half a dozen or so correct options it could be and remove anything else.

It's easiest to use placeholders or a combination of $dbh->quote and $dbh->quote_identifier.