Ho w can I do to combine two columns into one and use this whole column as where condition

I am referring to URL:

https://cap.cloud.sap/docs/java/query-api

Please get back to me on the following feedback:

For EX,

I want to use below CQL to combine two columns into one column, and put into In statement. How can I do this?

Select.from(Test.class).where(t -> (t.id() + t.name()).in(["0001Test1","0002Test2"])