Build, test, and debug regular expressions
Parses database data type definitions by extracting the type name, precision, and scale components. Matches patterns like `VARCHAR2(100)` or `NUMBER(10,2)`, capturing the type identifier (letters and digit 2), optional precision value, and optional scale value. Commonly used in SQL parsing, schema validation, or ORM metadata processing.