[FEATURE] Allow regex search

[cceyda]

Is your feature request related to a problem? Please describe.

I'm searching through records in the UI and can't match using regex:

Example:

• My record is : "blah blah 3apples on the tree"
• If I search for "apples" it doesn't show up on the results because there is no space between "3" and "apples"
• It only shows on search results if my record is like: "3 apples on the tree"

This used to be possible to search with "*apples*" regex because on the backend it was using a type of search that supported regex but now it is using 'simple_query_string' which doesn't support this (More discussion on discord)

This is especially critical for languages where spacing isn't strictly adhered to ie: Chinese,Japanese,Korean
Where the lack of this functionality basicall makes whole search functionality meaningless 😢

Describe the solution you'd like

Have tick box or an option to enable the old type of searching through records(like back in v1) using regex.
This

{
  "query": {
    "query_string": {
      "query": "fields.title:*mysubstring*"
    }
  }
}

or this

{
  "query": {
    "wildcard": {
      "fields.title": {
        "value": "*mysubstring*"
      }
    }
  }
}

This type of search works better than the current limited simple_query_string type of search. I understand this was due to some optimization due to performance but I would rather have the option to do slower queries than not have the functionality at all

Describe alternatives you've considered

Not possible at all through UI

Additional context

I would say this is critical as it was the thing I liked most about argilla before. The data visibility and ease of discovery.
visibility is currently limited due to permissions where admin is not able to see submitted records and discovery is hindered largely by this issue 😭 Also a pain point that was pointed out very very quickly back to us by our annotators, like if they make a mistake and want to change it there is no way for them to find the thing they are looking for easily right now