Hi,
HQL doesn't support the following SQL query to be converted into the HQL. If column1, column2 , column3 are not primary key/ID of the table.
select * from table where (column1, column2 , column3) in (('A','B','C'),('D','E','F'));