title: Python regex to match quoted string with escaped single quotes
body: <p>I was using this pattern to match single quoted strings in parser:</p>
  
  <pre><code>"'.+?'"
  </code></pre>
  
  <p>But I need regex that can find single quoted string with postgres like escape of single qoutes (doubling single qoutes). Need to match something like this:</p>
  
  <pre><code>"'first', 'sec''ond', 't''hi''rd'"
  </code></pre>
  
  <p>I want to find shortest matches for strings that start and end with single single quotes, so the string above would mean 3 substrings:</p>
  
  <pre><code>'first'
  'sec''ond'
  't''hi''rd'
  </code></pre>