I have the following (partial) SQL query:

Furthermore, I have the following java code to support it:


My issue is, that in order to use the parameterlist as a pseudo-table the way I am above (taking the Cartesian product with the queried table so I can find out which card sequence ranges surround ANY of the cardserialNos), I need to learn what needs to go in the SQL query rather than csnt.THING.

Basically:
What is the proper column name of the hibernate parameter list pseudo-table?

That's not supported via JPQL. You need to use Criteria API if you want to vary the Entity or Table name.

I see. Unfortunate.

I have been reading up on the Criteria API, but I am not quite yet seeing how I would do this with it.
Is there any sort of tutorial you could point me to?

We have a chapter dedicated to the Criteria API in our User Guide, which is a good place to start.

However, your query is not a typical one, so the chance of finding a tutorial that explain exactly your problem is rather low. Hence, my suggestion. Just Google "JPA Criteria API" + whatever you are interested in doing.

This way, you can easily find the following answers:

1. This StackOverflow answer shows how to use a Subquery for the IN clause.
2. This StackOverflow answer shows how to create the Cartesian Product for the subquery.