@DBFlute, Java DBFlute-0.9.7.3 was released. Change Log Migration Point This supports "And" connector in OrScopeQuery.
where ... and ((FOO_TYPE = 'FOO1' and BAR_TYPE = 'BAR1') or (FOO_TYPE = 'FOO2' and BAR_TYPE = 'BAR2') or (FOO_TYPE = 'FOO3' and BAR_TYPE = 'BAR3') ) )