You can use Qualification slot inside the step to write the qualification.
I believe all the above can be done, yes.
The qualification field is not present on the CMDBLookup component. We only have it for CMDBInput and CMDBOutput. So it seems impossible to have a query using "IN" or "OR".
In general, the CMDB components are not well documented.
What is the use of the field1 and field2 in the Lookup values table?
Yes, you are correct. IN is not a possible comparator. OR is not a possible operator.
Field 2 is only to be used with the BETWEEN comparator.