title: How to avoid SQL RequestError: "The multi-part identifier ... could not be bound"?
body: <p>I am getting a SQL RequestError while trying to insert a string into a SQL Server table. The string is <code>com.redacted.redacted.redacted</code>. I think that the periods in the string are throwing some kind of red flag that it is a reference to some property of an object, or something along those lines. I am using the mssql node module for the request.</p>
  <pre><code>let myObj = {
      Date: '2015-06-22',
      PackageName: 'com.redacted.redacted.redacted'
  }
  
  let date = myObj['Date']
  let pName = myObj['PackageName']
  
  request.query('insert into myTable ([DATE],[PackageName]) values (' + date + ',' + pName + '))
  </code></pre>
  <p>I have not found anything online about trying to avoid using the dot notation, but I have found some of the opposite, trying to get into the notation. I also looked but there is no RegExp keyword to keep a period as literally a period.</p>
  <p>The exact Error:</p>
  <pre><code>REQ ERROR
  { [RequestError: The multi-part identifier &quot;com.redacted.redacted.redacted&quot; could not be bound.]
      name: 'RequestError',
      message: 'The multi-part identifier &quot;com.redacted.redacted.redacted&quot; could not be bound.',
      code: 'EREQUEST',
      number: 4104,
      lineNumber: 1,
      state: 1,
      class: 16,
      serverName: 'REDACTED',
      procName: '' }
  </code></pre>