Function parseColumnType

src/utils/columnTypes.ts:32–48

(
  fullType: string,
  availableTypes: DataTypeInfo[],
)

 * it is kept intact with no length extraction.
 */
export function parseColumnType(
  fullType: string,
  availableTypes: DataTypeInfo[],
): ParsedType {
  const upperFull = fullType.toUpperCase().trim();
  const exactMatch = availableTypes.find(
    (t) => t.name.toUpperCase() === upperFull,
  );
  if (exactMatch) {
    return { type: exactMatch.name, length: "" };
  }
  const match = fullType.match(/^([a-zA-Z0-9_[\] ]+)(?:\((.+)\))?$/);
  if (match) {
    return { type: match[1].toUpperCase().trim(), length: match[2] || "" };
  }
  return { type: upperFull, length: "" };
}

/**
 * Build a ColumnDefinition (backend-compatible) from a form data object.