title: Spring JPA long SQL String for NativeQuery
body: <p>In my Spring JPA Project, I have a repo file as such:</p>
  
  <pre><code>@Repository
  public interface StudentRepository extends JpaRepository&lt;Student, Integer&gt;{
  
  @Query(value = "select * from students", nativeQuery = true)
  public List&lt;Student&gt; findStudents(
          @Param("keyword") String keyword
          );
  }
  </code></pre>
  
  <p>With this, I can still copy paste the SQL and run in my DB software.<br><br>
  But when it comes to large queries as such:</p>
  
  <pre><code>    @Query(value = "SELECT\n" + 
          "*\n" + 
          "FROM\n" + 
          "students\n" + 
          "WHERE\n" + 
          "(\n" + 
          "`id` LIKE CONCAT('%', :keyword, '%') OR\n" + 
          "`name` LIKE  CONCAT('%', :keyword, '%') OR\n" + 
          "`desc` LIKE  CONCAT('%', :keyword, '%') OR\n" + 
          "`sex` LIKE  CONCAT('%', :keyword, '%')\n" + 
          ")", nativeQuery = true)
  public List&lt;Student&gt; findStudents(
          @Param("keyword") String keyword
          );
  </code></pre>
  
  <p>I can't really directly copy paste and run in the DB software, I have to remove the "+" "\n" characters.
  I've tried Java's """SQL_QUERY_STRING""" but it doesn't allow it.</p>
  
  <p>Are there any alternative approach to this? </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I tried the triple double-quote but it gives:</p>
  
  <blockquote>
    <p>String literal is not properly closed by a double-quote</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/HQKda.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HQKda.png" alt="enter image description here"></a></p>