Function escapeLikePattern

apps/sim/lib/table/sql.ts:494–496

(value: string)

/** Escapes LIKE/ILIKE wildcard characters so they match literally */
export function escapeLikePattern(value: string): string {
  return value.replace(/[\\%_]/g, '\\$&')
}

/**
 * Builds a case-insensitive pattern match against a JSONB cell using ILIKE.