simple search api (was Re: mimetype standardisation by testsets)

[John Tapsell]

At the risk of stating the obvious, but why not just use SQL?

select files.filename from files,tags tag1, tags tag2 where files.id =
tag1.fileid and files.id = tag2.fileid  and tag1.key="artist" and
tag1.value="foobar" and tag2.key="group" and tag2.value="audio"


It seems that all the API is reinventing SQL.
Why not just use SQL in the first place?