how to convert a query from SQL to HQL(hibernate Query Language)

[shiniskumar]

I want to convert the following query from SQL to HQL.

SELECT
     student.first_name AS student_first_name,
     course.name AS course_name,
     course.id AS course_id,
     admission.admission_no AS admission_admission_no,
     attendance.status AS attendance_status,
case WHEN attendance.status=1 THEN 'P'
            WHEN attendance.status=2 THEN 'A'
End as Status,
    count(course.id) as Periods,
    count(attendance.status) as Total,
     time_table_item.tt_date AS time_table_item_tt_date,
     attendance.student_batch_id AS attendance_student_batch_id
FROM
     public.time_table_item time_table_item 
     INNER JOIN public.attendance attendance ON time_table_item.id = attendance.time_table_item_id
     INNER JOIN public.syllabus_course syllabus_course ON syllabus_course.id = time_table_item.act_syl_course_id
     INNER JOIN public.course course ON syllabus_course.course_id = course.id
     INNER JOIN public.student_batch student_batch ON attendance.student_batch_id = student_batch.id
     INNER JOIN public.admission admission ON student_batch.admission_id = admission.id
     INNER JOIN public.student student ON admission.student_id = student.id
     AND course.id = syllabus_course.course_id
INNER JOIN public.time_table time_table ON time_table_item.time_table_id = time_table.id
where 
    student_batch.batch_id= $P{Batch} and time_table.level_id= $P{Level} and syllabus_course.course_id = $P{Course}   --course.id=9142294     --course.id=9142294 
group by 
    course.id, admission.admission_no,time_table_item.tt_date,attendance.student_batch_id,
    student.first_name,attendance.status,course.name
order by
    course.id, admission.admission_no,time_table_item.tt_date
 

Can i get the corresponding HQL query for this?
Please help

[michaelb]

Perhaps this publication will put you on the track.

I don't know whether any conversion tools are available, but look at http://www.hibernate.org/ for what's being developed in this area.