Function normalizePartitionDefinition

packages/sql/src/schema/partitioning.ts:271–287

(value: string)

/** @internal */
export function normalizePartitionDefinition(value: string): string {
  const normalized = normalizeWhitespace(value);
  const match = /^(\w+)\s*(.*)$/.exec(normalized);
  const rawType = match ? match[1] : normalized;
  const type = rawType.toLowerCase();
  const expression = match ? match[2].trim() : '';

  if (!expression) {
    return type;
  }

  if (!expression.startsWith('(')) {
    return `${type} ${normalizePartitionSqlFragment(expression)}`;
  }

  return `${type} (${normalizePartitionSqlFragment(unwrapAllOuterParentheses(expression))})`;
}

const PARTITION_BOUND_KEYWORDS = /\b(for values|with|in|from|to|minvalue|maxvalue|null)\b/gi;