title: How to escape square brackets inside square brackets for field name
body: <p>I have some dynamic SQL that generates column names. A quick example might be something like this:</p>
  
  <pre><code>SELECT dbo.getSomething(123) [Eggs[scrambled] or Bacon[fried]]
  </code></pre>
  
  <p>The final column name should be this: </p>
  
  <blockquote>
    <p>Eggs[scrambled] or Bacon[fried]</p>
  </blockquote>
  
  <p>If I try to run this it will error on the word OR (even if I replace it with xyz it still errors on that token). The problem is fixed if I take out the inner sets of square brackets. So my conclusion is that you can't nest square brackets unless you somehow escape them.</p>
  
  <p>How do I escape them in this case?</p>