Description
Hello,
I am experiencing an issue with the latest update to Spring Boot, specifically with the new features introduced for syntax validation and highlighting in Visual Studio Code. The features in question are:
Syntax validation for JPQL, SQL, and HQL embedded in Java code.
Syntax highlighting for SQL embedded into Spring Data query annotations.
Since these features were introduced, I've encountered numerous false positives where valid queries are being flagged as errors. This issue seems to primarily affect the development environment in Visual Studio Code.
Steps to Reproduce:
Write a valid SQL/JPQL query embedded within Java code or Spring Data annotations.
Observe that the syntax validation incorrectly flags these valid queries as having errors.
Expected Behavior:
The syntax validation should accurately recognize valid SQL, JPQL, and HQL queries without flagging them as errors.
Actual Behavior:
Valid queries are being incorrectly flagged as errors, leading to unnecessary confusion and hindrance in the development process.
Could you please look into this issue? It seems that the new validation rules might be overly strict or not fully aligned with the actual syntax rules of SQL, JPQL, and HQL.