CiviCRM Community Forums (archive)

I am working on an extension to add "Do Not Contact Until" functionality. After retrieving details of the custom field group (using CRM_Core_BAO_CustomGroup) and its fields (using CRM_Core_BAO_CustomField), I am performing a custom query for each field in question. This query affects both the custom field and a corresponding column in civicrm_contact.
    UPDATE `$dncuTable` INNER JOIN `civicrm_contact`
        ON `$dncuTable`.`entity_id`           = `civicrm_contact`.`id`
       SET `civicrm_contact`.`$contactColumn` = 0,
           `$dncuTable`.`$dncuColumn`         = NULL
     WHERE `civicrm_contact`.`$contactColumn` = 1
       AND `$dncuTable`.`$dncuColumn`         IS NOT NULL
       AND DATE(`$dncuTable`.`$dncuColumn`)   <= CURDATE();This appears to work (after putting dropTriggers and triggerRebuild around it, as it appears to fall foul of something similar to CRM-13587). Is it, however, considered harmful to use custom SQL here in an extension that I'd like to eventually release?