hq hammond rock|metal !jazz year:1970-1980 rating:desc

becomes

SELECT * FROM music
WHERE search LIKE '%hammond%'
AND (search LIKE '%rock%' OR search LIKE '%metal%')
AND search NOT LIKE '%jazz%'
AND year BETWEEN 1970 AND 1980
ORDER BY rating DESC