SearchRequest enhancement with further SQL clauses

[loiclefevre]

Hello,
While working on the integration of Oracle Database 23ai with Spring AI, it appears to me that providing additional filtering clauses to the SearchRequest so as to probe other tables (SQL join / exists operator) containing related data (id field provided through metadata...) could speed up filtering and also enrich metadata results (projecting other tables columns into JSON objects).

What do you think about it?

Thanks