Function _extract_sql_position

marimo/_sql/error_utils.py:105–135

Extract line and column position from SQL exception message.

(
    exception_msg: str,
)

def _extract_sql_position(
    exception_msg: str,
) -> tuple[int | None, int | None]:
    """Extract line and column position from SQL exception message."""
    # SqlGlot format: "Line 1, Col: 15"
    line_col_match = re.search(r"Line (\d+), Col: (\d+)", exception_msg)
    if line_col_match:
        return (
            int(line_col_match.group(1)) - 1,  # Convert to 0-based
            int(line_col_match.group(2)) - 1,
        )

    # DuckDB format: "LINE 4:" (line only)
    line_only_match = re.search(r"LINE (\d+):", exception_msg)
    if line_only_match:
        return (
            int(line_only_match.group(1)) - 1,  # Convert to 0-based
            None,  # No column information
        )

    # SQLGlot format variations
    sqlglot_match = re.search(
        r"line (\d+), col (\d+)", exception_msg, re.IGNORECASE
    )
    if sqlglot_match:
        return (
            int(sqlglot_match.group(1)) - 1,
            int(sqlglot_match.group(2)) - 1,
        )

    return None, None


def create_sql_error_metadata(