Improve error message "Search field not found." in widget creation SQL UI

[soywiz]

Which OpenObserve functionalities are relevant/related to the feature request?

dashboards

Description

When there is an error in the SQL when generating a dashboard widget likemy_field <> "999.0.0.999" (where "999.0.0.999" should be '999.0.0.999'), the UI reports Error: search field not found., and that doesn't help to figure out the issue (in this case double quotes are used for identifiers in SQL, while single quotes for string literals).

Check this slack thread for details: https://zincobserve.slack.com/archives/C04QC53TPD2/p1687856924243639

Proposed solution

Include the field that was not able to be found like Error: search field '999.0.0.999' not found..

Alternatives considered

Include the index in the string where the field was not found. But might not be as useful.