@sqlrooms/db

DuckDB-centered orchestration layer for SQLRooms multi-database execution.

Purpose

• Keep DuckDB as the core runtime for SQL execution DAG semantics.
• Register and route connector execution for external engines.
• Aggregate connector catalogs/schemas into one explorer view.
• Materialize non-DuckDB results into core DuckDB with a configurable policy.

Notes

• This package is intentionally additive and keeps @sqlrooms/duckdb APIs intact.
• Default materialization strategy is strict ephemeral attached database mode.

Interfaces

• BaseDuckDbConnectorOptions
• BaseDuckDbConnectorImpl
• QueryOptions
• DuckDbConnector
• TypedRowAccessor

Type Aliases

• RuntimeSupport
• DbEngineId
• CoreMaterializationStrategy
• CoreMaterializationStrategy
• CoreMaterializationConfig
• CoreMaterializationConfig
• DbConnection
• CatalogDatabase
• CatalogSchema
• CatalogTable
• CatalogColumn
• CatalogTableDetails
• DbConnectorCapabilities
• DbConnector
• DbBridge
• QueryExecutionRequest
• QueryExecutionResult
• CatalogEntry
• DbSliceConfig
• DbSliceState
• DbRootState
• QueryHandle
• FunctionSuggestion
• GroupedFunctionSuggestion
• QualifiedTableName
• SeparatedStatements
• ColumnTypeCategory
• DbSchemaNode
• NodeObject
• ColumnNodeObject
• TableNodeObject
• SchemaNodeObject
• DatabaseNodeObject
• TableColumn
• DataTable

Variables

• RuntimeSupport
• DbEngineId
• DbConnection
• escapeVal
• escapeId
• isNumericDuckType
• getSqlErrorWithPointer
• getFunctionDocumentation
• getFunctionSuggestions

Functions

• createDbSlice
• useStoreWithDb
• createHttpDbBridge
• createCoreDuckDbConnection
• isCoreDuckDbConnection
• getCoreDuckDbConnectionId
• useSql
• createBaseDuckDbConnector
• arrowTableToJson
• isQualifiedTableName
• makeQualifiedTableName
• getColValAsNumber
• splitSqlStatements
• sanitizeQuery
• makeLimitQuery
• separateLastStatement
• joinStatements
• load
• loadCSV
• loadJSON
• loadParquet
• loadSpatial
• loadObjects
• sqlFrom
• literalToSQL
• createDbSchemaTrees
• getDuckDbTypeCategory
• getArrowColumnTypeCategory
• createTypedRowAccessor