Function create_sql_error_metadata

marimo/_sql/error_utils.py:138–183

Create structured SQL error metadata from an exception. This is the single source of truth for parsing SQL exceptions into metadata.

(
    exception: BaseException,
    *,
    rule_code: str,
    node: ast.expr | None = None,
    sql_content: str = "",
    context: str = "",
)

def create_sql_error_metadata(
    exception: BaseException,
    *,
    rule_code: str,
    node: ast.expr | None = None,
    sql_content: str = "",
    context: str = "",
) -> SQLErrorMetadata:
    """Create structured SQL error metadata from an exception.

    This is the single source of truth for parsing SQL exceptions into metadata.
    """
    exception_msg = str(exception)
    sql_line, sql_col = _extract_sql_position(exception_msg)

    # Truncate long SQL content
    truncated_sql = sql_content
    if sql_content and len(sql_content) > 200:
        truncated_sql = sql_content[:200] + "..."

    # Create clean error message (first line only)
    clean_message = exception_msg.split("\n", 1)[0]

    # Extract helpful DuckDB hints separately (including multiline hints)
    hint = None
    lines = exception_msg.split("\n")
    hint_lines = []

    for line in lines[1:]:
        hint_lines.append(line.strip())

    if hint_lines:
        hint = "\n".join(hint_lines)

    return SQLErrorMetadata(
        lint_rule=rule_code,
        error_type=type(exception).__name__,
        clean_message=clean_message,
        hint=hint,
        node_lineno=node.lineno if node else 0,
        node_col_offset=node.col_offset if node else 0,
        sql_statement=truncated_sql,
        sql_line=sql_line,
        sql_col=sql_col,
        context=context,
    )


def metadata_to_sql_error(metadata: SQLErrorMetadata) -> MarimoSQLError: