title: Error - expected <block end>, but found '<scalar>'
body: <p>I am struggling with a SQL query in a YAML file. I have tested my SQL query in my database, which works perfectly. </p>
  
  <p>This is my query in my Ansible file: </p>
  
  <pre><code>shell: "{{ scrub_command }} -c \"UPDATE project_record SET meta=jsonb_set(meta, '{"email"}', concat('"', meta-&gt;&gt;'email', '.not"')::jsonb) WHERE meta-&gt;&gt;'email' IS NOT NULL AND meta-&gt;&gt;'email' NOT ILIKE '%@email.somethingelse.com' AND meta-&gt;&gt;'email' NOT ILIKE '%@something.com';\""
  </code></pre>
  
  <p>I can see that in the editor, my query is not ending properly as the <code>\"</code>  has a different color from the opening <code>\"</code>). </p>
  
  <p>If I take out the part: </p>
  
  <pre><code>concat('"', meta-&gt;&gt;'email', '.not"')::jsonb)
  </code></pre>
  
  <p>the query is closing properly. </p>
  
  <p>I have tried playing with the query and testing it in YAML lint website, but I can't find a way for my YAML file to accept my query.</p>
  
  <p>The error I get when running my script is:</p>
  
  <pre><code>Syntax Error while loading YAML.\n  expected &lt;block end&gt;, but found '&lt;scalar&gt;'
  </code></pre>
  
  <p>The YAML lint website would give this error: </p>
  
  <pre><code>did not find expected key while parsing a block mapping at line 1 column 1 
  </code></pre>
  
  <p>What I am doing wrong?</p>