Fuzzy match in Explorer tree Find on an ISFS folder not fixed by #1443

[gjsjohnmurray]

#1444 got Explorer Find working again for 1.94 but didn't deal with fuzzy match mode.

Related to microsoft/vscode#230483 (comment)

I will prepare a PR.

[isc-bsaviano]

@gjsjohnmurray I was messing around with a function that does this in the past. Not sure if it's complete though becuase it doesn't handle glob characters. It also converts the pattern to lowercase so in the query the column needs to be wrapped in LOWER. The explicit LOWER is needed because come columns have exact collation, so LIKE is case sensitive for them.

/** Convert `query` to a fuzzy LIKE compatible pattern */
export function queryToFuzzyLike(query: string): string {
  let p = "%";
  for (const c of query.toLowerCase()) p += `${["_", "%", "\\"].includes(c) ? "\\" : ""}${c}%`;
  return p;
}