Standalone SQL editor (back)

Two host-built CodeMirror editors mounted outside the data table, each one assembled by hand from createSqlExtensions() + buildCompletionContext(). Both editors share the loaded table's live schema via actions.getCompletionContext() and refresh whenever a derived column is added. Type Ctrl/Cmd+Space to see column names (with their DuckDB types) and DuckDB functions (with category + description) in the dropdown.

Live schema

Pulled from table.actions.getCompletionContext(); refreshed on every derivedChange.

Filter SQL composer

Compose a raw WHERE clause. Validate uses actions.validateSQLFilter; Apply calls actions.addRawSQLFilter.

Derived expression composer

Compose a column expression. Validate uses actions.validateExpression; Add column calls actions.addDerivedColumn({ kind: 'expression' }).

Name: