Launch it with $ duckdb -ui if you have version 1.2 or later.
duckdb UI can have multiple databases including in memory database attached. Can explore the databases using Table summary, the notebooks are useful in organizing work into notebooks. SQL is the language of the notebooks like python is for jupyter notebooks. The notebook cells support syntax highlighting and autocompletion.
The results can be visualized using the column explorer, which shows the summary of the results. It is “type aware”, and thus can visulize things like percentiles, median etc.
Interestingly, the the UI extension is all written in cpp - https://github.com/duckdb/duckdb-ui
Note: there were some concerns about the UI not being functional totally locally (ie., won’t work without internet connection). That’s not a big concern for me, but something to keep in mind.