Bug HHH-3123 Closed was closed as trivial. It is not trivial. It is the result of an incompetent or lazy developer, which is misleading users with a completely useless error message.

When Hibernate is encountering a query with an extraneous parenthesis, instead of reporting a malformed query or the extraneous parenthesis, it reports a 'NullPointerException'. In summary, Hibernate code crashed, with zero clue what happened.

The bug I am reporting is the totally useless error message being shown. Error reporting is not trivial and it takes some competence to report an error correctly. Incompetent error reporting, as in this case, makes users waste time simply because the developer couldn't be bothered.

Please report the error with some clue. Providing hints, such as 'Do you have extraneous parenthesis' would be helpful. Hibernate already prints such messages, so the idea is not novel.
Please use the pattern that you yourself seemed to have considered as correct, and just type in the extra few lines at the right place.