title: expecting IDENT, found ':'
body: <p>I am building a native query for my Spring project. Anyone has any idea what the issue is?</p>
  <pre><code>@Query(value = &quot;SELECT e.first_name as firstName, e.last_name as lastName, jh.start_date as startDate, jh.end_date as endDate, &quot; +
                  &quot;j.job_title as jobName, d.department_name as departmentName FROM JOB_HISTORY jh &quot; +
                  &quot;JOIN JOBS j ON jh.JOB_ID = j.JOB_ID &quot; +
                  &quot;JOIN DEPARTMENTS d ON JH.DEPARTMENT_ID = d.DEPARTMENT_ID &quot; +
                  &quot;JOIN EMPLOYEES e ON jh.EMPLOYEE_ID = e.EMPLOYEE_ID &quot; +
                  &quot;ORDER BY jh.:sortBy :orderBy&quot;)
          List&lt;EmployeeJobView&gt; getAllEmployeeJob(String sortBy, String orderBy);
  </code></pre>
  <blockquote>
  <p><strong>org.hibernate.hql.internal.ast.QuerySyntaxException: expecting IDENT,
  found ':' near line 1, column 348</strong> [SELECT e.first_name as firstName,
  e.last_na me as lastName, jh.start_date as startDate, jh.end_date as
  endDate, j.job_title as jobName, d.department_name as departmentName
  FROM JOB_HISTORY jh JOIN JOBS j ON jh.JOB_ID = j.JOB_ID JOIN
  DEPARTMENTS d ON JH.DEPARTMENT_ID = d.DEPAR TMENT_ID JOIN EMPLOYEES e
  ON jh.EMPLOYEE_ID = e.EMPLOYEE_ID ORDER BY jh.:sortBy :orderBy]</p>
  </blockquote>