We have a requirement to select the required columns based on the few conditions and same with where conditions as mentioned below example.
Could you please help how can i achieve this in HQL writing in the xml file. I don't want to use Criteria for this. Is there way Hibernate supports integration with velocity?
Highly appreciate your inputs.

<sql-query>
select
a
#if($isomeCondition=='Y')
,c
#end
from
table
where
a = '12'
#if($isomeCondition=='Y')
and c is like '%a%'
#end
</sql-query>

There's no integration with Velocity. In fact, this is the whole purpose of having Criteria API, so that it provides a mechanism to build dynamic entity queries dynamically. The JPA Criteria API allows you to benefit from typesafe queries as well by using the entity Metamodel.