Allow query annotation which contains only the where part [DATAJDBC-225]

[spring-projects-issues]

Jens Schauder opened DATAJDBC-225 and commented

Provide a way to specify a query by only specifying the where clause.

This would allow becoming independent of the table-name and the columns and their aliases.

On the other hand, a where-clause might use joined tables and thereby become dependent on what joins we generate and what aliases we use

---

No further details from DATAJDBC-225

[spring-projects-issues]

Jens Schauder commented

My current thinking is to maybe allow something like

@Query(alias="main" value="<sql-snippet>")

where sql-snippet gets prefixed with whatever select, from, and join clause Spring Data JDBC uses, including aliasing the table mapped to the aggregate root as main or whatever was used for alias.

The alias would flag the query as only a snippet and also would make it possible to add joins for the condition, while limiting the dependence on how Spring Data JDBC queries the data. It would also actually disallow referencing joins or similar created by Spring Data JDBC in the where clause which I consider a good thing because it prevents loading of partial entities which would wreak havoc when persisted.