Support syntax highlighting for Spring JPA like queries

[nickzhums]

Per customer feedback, support syntax highlighting for Spring JPA like queries such as this screenshot:

[martinlippert]

Related issue in the Spring Tools 4 issue tracker: spring-projects/spring-tools#1114

[martinlippert]

Please watch spring-projects/spring-tools#1114 for the latest progress on this.

[nickzhums]

Thanks @martinlippert !

[martinlippert]

@nickzhums If you switch to the pre-release build of the Spring Boot Tools extension, you can already try out the syntax highlighting for query annotations.

But we don't have diagnostics (yet) - as shown in the screenshot for the misspelled selecy word.

[nickzhums]

this is great, thanks a lot, will try it

[github-actions]

Hi @nickzhums, I'm an AI Support assistant here to help with your issue. While the team reviews your request, I wanted to provide some possible tips and documentation that might help you in the meantime.

Currently the Java extension uses the upstream TextMate grammar, which doesn’t recognize SQL inside @Query("…") strings. There isn’t built-in support yet, but you can try these workarounds:

• Install an embedding SQL highlighter, e.g.:
– SQLTools (https://marketplace.visualstudio.com/items?itemName=mtxr.sqltools)
– vscode-sql-flavor (https://marketplace.visualstudio.com/items?itemName=adpyke.vscode-sql-flavor)
• Use a generic “language injection” extension to mark your literal as SQL

We’ve filed this as an enhancement to inject SQL highlighting in Java strings—please upvote:

• Feature request: redhat-developer/vscode-java#1048 (comment)

labels:

• enhancement

duplicateUrls: []

The team will respond to your issue shortly. I hope these suggestions are helpful in the meantime. If this comment helped you, please give it a 👍. If the suggestion was not helpful or incorrect, please give it a 👎. Your feedback helps us improve!

[martinlippert]

This is already implemented and released as part of the https://github.com/spring-projects/spring-tools/, at least for Spring related projects, so feel free to close this issue here.