Multi-line SQL is allowed, but must be terminated by a semicolon. Dot commands must be newline-terminated.
Configuring the Script Location
By default, Harlequin will execute the script found at
~/.duckdbrc. However, you can provide a different path using the
--init-path option (aliased to
$ harlequin --init-path path/to/my/script.sql
If you would like to open Harlequin without running the script you have at
~/.duckdbrc, you can either pass a nonexistent path to the option above, or start Harlequin with the
$ harlequin --no-init
Supported Dot Commands
Most DuckDB CLI dot commands affect the behavior of the CLI, like the format of its output. Since these are irrelevant to Harlequin, they are ignored.
Currently Harlequin rewrites the following dot commands to SQL and executes the SQL:
.openis rewritten to
To request additional dot command support in Harlequin, open an issue.