This JPA query is valid when using Hibernate as the provider:
@Query("SELECT foo FROM Foo foo WHERE YEAR(foo.date) IN ?1")
But in a Spring Boot project, IDEA falsely marks it as an error with this message:
Error:(37, 102) <expression>, <operator>, GROUP, HAVING or ORDER expected, got '('
Is this a bug in IDEA or do I have to do something special to enable it?