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

[shiniskumar]

I want to convert the following query from SQL to HQL.
[CODE=sql]
SELECT
student.first_n ame AS student_first_n ame,
course.name AS course_name,
course.id AS course_id,
admission.admis sion_no AS admission_admis sion_no,
attendance.stat us AS attendance_stat us,
case WHEN attendance.stat us=1 THEN 'P'
WHEN attendance.stat us=2 THEN 'A'
End as Status,
count(course.id ) as Periods,
count(attendanc e.status) as Total,
time_table_item .tt_date AS time_table_item _tt_date,
attendance.stud ent_batch_id AS attendance_stud ent_batch_id
FROM
public.time_tab le_item time_table_item
INNER JOIN public.attendan ce 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.stud ent_batch_id = student_batch.i d
INNER JOIN public.admissio n admission ON student_batch.a dmission_id = admission.id
INNER JOIN public.student student ON admission.stude nt_id = student.id
AND course.id = syllabus_course .course_id
INNER JOIN public.time_tab le time_table ON time_table_item .time_table_id = time_table.id
where
student_batch.b atch_id= $P{Batch} and time_table.leve l_id= $P{Level} and syllabus_course .course_id = $P{Course} --course.id=91422 94 --course.id=91422 94
group by
course.id, admission.admis sion_no,time_ta ble_item.tt_dat e,attendance.st udent_batch_id,
student.first_n ame,attendance. status,course.n ame
order by
course.id, admission.admis sion_no,time_ta ble_item.tt_dat e
[/CODE]

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.