[最佳答案] So after a lot of time searching for the right answer, the only real solution that works for us is creating a view: CREATE VIEW TableA_view AS SELECT TableOne.*,TableTwo.id FROM TableA JOIN TableTwo ON TableOne.address = ANY(TableTwo.addresses) and mapping it to an entity TableOne instead of the original table. This was the only solution for us besides, of course, using a named query, which was a no-go as we needed to stick to the Criteria API. As @ericbn has mentioned in the comments this is r