Support for wildcards at beginning of SQL queries
According to Microsoft documentation, "Prefix matching is also supported with phrases specified in property values, but you must use the wildcard operator (*) in the query, and it is supported only at the end of the phrase." This is extrememly limiting. Why can't the wild card be anywhere in the query? This functionality would be great.

As we don’t support SQL usage with SharePoint, this seems to be in a wrong UserVoice and closing the request.