Skip to content

The REPL

Synopsis

dql query --db <database>

Description

When dql query is invoked without a query string and stdin is a terminal, the interactive REPL starts. It provides line editing, history, and tab completion for dot commands.

Dot commands

Command Description
.help Show available commands
.exit Quit the REPL
.version Show version information
.info Show session information
.sql Switch to SQL passthrough mode
.dql Switch back to DelightQL mode
.to <stage> Set default --to stage for the session
.format <fmt> Set default output format
.debug-last Show debug info for the last query
.debug-last-dump Dump full debug state for the last query
.record-start Start recording queries and results
.record-stop Stop recording
.record-status Show recording state

SQL passthrough

After .sql, input is sent directly to the database as raw SQL, bypassing the DelightQL compiler. .dql returns to normal mode.

Multi-line input

Incomplete expressions are accumulated across lines. The prompt changes to indicate continuation.

See Also

dql-query(1)