Panache simplfied query + CTE with

[zakariafadili]

Describe the bug

Hibernate ORM panache does not recognize syntax starting with "WITH" according to the syntax provided in Hibernate 2.0 for enabling recursive queries (CTE).

In fact, the query "WITH xxx AS (Select ...) Select * FROM xxx" is replaced by "FROM *** WHERE WITH..." which is incorrect.

Expected behavior

No response

Actual behavior

No response

How to Reproduce?

No response

Output of uname -a or ver

No response

Output of java -version

No response

GraalVM version (if different from Java)

No response

Quarkus version or git rev

3.2

Build tool (ie. output of mvnw --version or gradlew --version)

No response

Additional information

No response

[quarkus-bot]

/cc @FroMage (panache), @loicmathieu (panache)

[StephenOTT]

+1

[vedantshetty]

+1

[FroMage]

Ah yes, this is a recent HQL change indeed, we need to fix our query parsing.