Searching - SQL Search

[quant]

this suggestion has my vote, especially if only "passive" searches are allowed, ie. no update/delete as those could essentially be done afterwards on the found items (where the proper checks are already implemented).

But as was mentioned elsewhere, maybe being able to search through parent/child attributes would be enough for the beginning. This should be straightforward to implement ;-)
Just triple the list of available attributes in the advanced search (second and third copy of attributes preceded with parent: and child: respectively) and do the proper sql queries on the backend ;-)