Column name "use" is a reserved word in MySQL, in extension makes this module incompatible with other RDBMSes

The table created by salesforcewebform has a column named use which is a reserved word in MySQL. This is against the SQL coding conventions in Drupal.

As I understand it, the column names in the SQL queries performed by this module are quoted to avoid this problem. Unfortunately the quoting style used (`...`) is not standard SQL and cause this module to fail with other databases (such as PostgreSQL).

The code with the incompatible quoting is:

<?php
function salesforcewebform_nodeapi(&$node, $op, $form = NULL, $page = NULL) {
     if ( $node->type == 'webform') {

          switch ($op) {
          case 'insert':
          case 'update':
               if ( isset($node->use_salesforce) ) {
                    // store the SalesForce fields
                    $result = db_query("DELETE FROM {salesforcewebform} where `vid` = %d", $node->vid);
                    $result = db_query("INSERT INTO {salesforcewebform} (`vid`, `use`) " .
                                       "VALUES (%d, %d)", $node->vid, $node->use_salesforce);
               }
          break;
          case 'validate':

               break;
          case 'load':
               $result = db_query("SELECT `use` from {salesforcewebform} ".
                                  "WHERE `vid` = %d", $node->vid);
               // either $result has 0 or 1 rows, if we have one then add it to the node
               $row = db_fetch_array($result);

               if ( $row['use'] == '1' ) {
                    $node->use_salesforce = TRUE;
               }
               else {
                    $node->use_salesforce = FALSE;
               }
               break;
          }
     }
}
?>

As a side note the SQL doesn't use UPPERCASE for all reserved words (WHERE and FROM) as required by the conventions.