title: org.postgresql.util.PSQLException: ERROR: syntax error at or near ":"
body: <p>I am running an SQL query from PgAdmin4 which runs successfully, but when i take that same query to run it from my Spring Boot application i have an error " org.postgresql.util.PSQLException: ERROR: syntax error at or near ":" "</p>
  
  <p>Here is what the SQL query looks like:</p>
  
  <pre><code>SELECT
     student.surname, student.first_name, student.last_name,
     jsonb_pretty(elems)
  FROM assessment, jsonb_array_elements(assessment.assessment) AS elems
  JOIN student ON student.id = (elems-&gt;&gt;'student_id')::uuid
  WHERE subject_id = 2
  AND academy_year_id =3
  AND form_id = 2
  AND term_id = 1
  AND section_id = 4;
  </code></pre>
  
  <p>And this run successfully from PgAdmin4.</p>
  
  <p>This is my implementation in my Repository</p>
  
  <pre><code>@Query(nativeQuery = true, value = "SELECT\n" +
          "       student.surname, student.first_name, student.last_name,\n" +
          "       jsonb_pretty(elems)\n" +
          "FROM assessment, jsonb_array_elements(assessment.assessment) AS elems\n" +
          "JOIN student ON student.id = (elems-&gt;&gt;'student_id')::uuid\n" +
          "WHERE subject_id = 2\n" +
          "AND academy_year_id =3\n" +
          "AND form_id = 2\n" +
          "  AND term_id = 1\n" +
          "AND section_id = 4;")
  Object[] getSubjectAssessments();
  </code></pre>
  
  <p>And when my API calls this method i get this error message</p>
  
  <pre class="lang-none prettyprint-override"><code>org.postgresql.util.PSQLException: ERROR: syntax error at or near ":" 
  </code></pre>
  
  <p>I don't know what I am doing wrong.</p>