Function sanitizeIdentifier

apps/sim/app/api/tools/postgresql/utils.ts:65–72

(identifier: string)

}

export function sanitizeIdentifier(identifier: string): string {
  if (identifier.includes('.')) {
    const parts = identifier.split('.')
    return parts.map((part) => sanitizeSingleIdentifier(part)).join('.')
  }

  return sanitizeSingleIdentifier(identifier)
}

/**
 * Validates a WHERE clause to prevent SQL injection attacks