Textual search/ query
Writing a textual based SQL like search for documents. Close to a Westlaw syntax.
This search has a syntax error:
select field1, field2,, field3 from documents
Should I tell them the ",," is wrong and make them fix it or just remove the second ","?
Would you go even further and if the field name is not correct but within one or two characters of a valid name then replace it. In the select it would be non-destructive. In the where I would not auto-fix.
where subjext = 'spam'
My users are not technical and impatient but amazingly like a Westlaw like syntax