sequenceDiagram
    participant User as User
    participant Header as Column Header
    participant FilterMenu as Filter Menu (Number/Text)
    participant PillEditor as Filter Pill Editor
    participant FilterPills as Filter Pills (Display)
    participant ValuesPicker as FilterByValuesList/CreatablePicker
    participant RegexInput as Regex Input
    participant FilterModel as Shared Filter Models (filters.ts)
    participant OperatorLabels as operator-labels.ts
    participant Backend as Backend API

    Note over User,Backend: NEW: Expanded column filter operators and pill-editor UX

    User->>Header: Click column header to open filter options
    Header->>FilterMenu: Render NumberFilterMenu or TextFilterMenu based on column data type

    alt Number column
        FilterMenu->>OperatorLabels: Retrieve labeled operator options
        OperatorLabels-->>FilterMenu: Full operator list (between, ==, !=, >, >=, <, <=, is_null, is_not_null)
        FilterMenu->>FilterMenu: Operator selection triggers immediate commit for nullish ops
        FilterMenu->>User: Display value/min-max inputs based on selected operator
        User->>FilterMenu: Fill value fields
        alt Apply disabled until valid
            FilterMenu->>FilterMenu: Check required fields (min+max for between, value for comparison)
            FilterMenu-->>User: Apply button disabled + tooltip
        end
        User->>FilterMenu: Click Apply or press Enter
        FilterMenu->>FilterModel: Build filter object via Filter.number()
        FilterModel-->>Header: Apply filter to column
        Header->>Backend: Send filter conditions (single operator+value pair)
    else Text column
        FilterMenu->>OperatorLabels: Retrieve labeled operator options
        OperatorLabels-->>FilterMenu: Full operator list (contains, equals, regex, starts/ends with, in, not_in, is_empty, is_null, is_not_null)
        alt In/not_in operator selected
            FilterMenu->>ValuesPicker: Render creatable FilterByValuesList
            User->>ValuesPicker: Type to search
            alt Query matches no existing values
                ValuesPicker-->>User: Show "+ Add 'query'" option
                User->>ValuesPicker: Select or press Enter to create
                ValuesPicker->>FilterModel: Commit new value
            end
            ValuesPicker-->>FilterMenu: Return selected values
        else Regex operator selected
            FilterMenu->>RegexInput: Render slash-bracketed input (/pattern/flags)
            User->>RegexInput: Type regex pattern between slashes
            RegexInput-->>FilterMenu: Return pattern string
        else Single-string operators (contains, equals, etc.)
            FilterMenu->>User: Show text input seeded from current filter
            User->>FilterMenu: Edit text value
        end
        User->>FilterMenu: Click Apply or press Enter
        FilterMenu->>FilterModel: Build filter object via Filter.text()
        FilterModel-->>Header: Apply filter to column
        Header->>Backend: Send text condition (single operator+string)
    end

    Note over Header,PillEditor: NEW: Filter pill editor with full operator awareness

    User->>PillEditor: Open pill editor from existing filter pill
    PillEditor->>FilterModel: Extract operator and draft value from snapshot
    alt Operator switch incompatible
        PillEditor->>PillEditor: Clear draft value for new operator type
        User->>PillEditor: Enter new value
    else Operator switch compatible
        PillEditor->>PillEditor: Preserve draft value
    end
    User->>PillEditor: Edit column, operator, or value
    PillEditor->>PillEditor: Rehydrate snapshot if matches original column+operator
    User->>PillEditor: Submit form (Enter or Apply button)
    alt Apply disabled
        PillEditor-->>User: Show tooltip with missing value message
    else Apply valid
        PillEditor->>FilterModel: Build filter value from draft
        FilterModel->>Backend: Commit filter via setColumnFilters
        Backend-->>PillEditor: Filter applied
        PillEditor-->>User: Close editor
    end

    Note over FilterPills,Backend: CHANGED: Pill display per operator type

    FilterPills->>FilterModel: Read current filter value
    FilterPills->>OperatorLabels: Map operator to display label
    alt Number filter
        FilterPills->>FilterPills: Format operator+value (e.g., "> 18", "between 1 - 9")
    else Text filter
        FilterPills->>FilterPills: Format per operator (e.g., "contains 'hello'", "is in [a, b]")
    else Nullish/is_empty
        FilterPills->>FilterPills: Show operator label only (e.g., "is null", "is empty")
    end
    FilterPills-->>User: Display formatted filter pill

    Note over FilterModel,Backend: CHANGED: Number between emits single condition

    FilterModel->>Backend: Convert filter to condition(s)
    alt Number between
        FilterModel->>Backend: Single "between" condition with {min, max} value
    else Number comparison
        FilterModel->>Backend: Single condition with operator+value
    else Text operators
        FilterModel->>Backend: Single condition per operator type
    else Nullish/is_empty booleans
        FilterModel->>Backend: Condition with no value field
    end
    Backend-->>FilterModel: Return filtered data