There are situations when we have complex SQL queries and we wish that it is possible to convert sql into hql using some tool or Hibernate API.

That can be time saving and efficient way for those who are relatively new to HQL/Hibernate.

1) Is there any tool that converts raw SQL into HQL?
2) Is there any Hibenate API using which we may create Query from raw SQL and then see the HQL generated by Hibernate, may be on debug console?

I looked for this sorta thing a while back.

Unfortunately, to my knowledge, there is nothing available. You can use a session.createSQLQuery() and pass it your real query, but there is not anything that will then take that Query object and change it into HSQL.

Go ahead and write one and sell it and make money. :)

Dont forget to rate! :)

Why do you care so much of converting SQL to HQL?, Hibernate will convert them back to SQL anyway ...
Simply get Connection from Hibernate and run it using SQL. I do it with all my complex queries (It is a reports system, that somethimes runs about 10 queries in order to produce a single report).
When it comes to real complexity, for my opinion, it is better using SQL directly, especially if you need specific SQL server semantics like "if"/"case" conditions, or specific functions usage.