I was throwing out ideas, rather than a fully-formed solution. I hope no-one implements my random musings without thinking about it a bit more!

It also occurred to me that we get a choice of doing this at database build time or on the fly as a search. (another unconsidered random idea to throw into the brainstorm pot...)