cds-dbs
cds-dbs copied to clipboard
feat(search): enable deep search with path expressions
support search via path expressions:
- deep search via associations
- include calculated elements if explicitly requested
to make this work, a non-enumerable searchTerm
is attached to the SELECT.search
object during inital infer call. The columns which should be searchable must be calculated early because the references need to be considered while building the joinTree
for the given query.
In cqn4sql
the fully linked search refs are then transformed as a regular function.
rework of https://github.com/cap-js/cds-dbs/pull/252