Usage of ConditionBuilder?

Hello,

I would like to implement a table to enhance the searching experience. E.g. two tables, one is called post, another post_tags. Is it possible to use a single query here to filter the post from the post_tags table?

I noticed, there is a conditionBuilder, is there a way to achieve this?

Thanks and Regards,
Mike