Feature: In CLI get output of query in a bash script friendly format.

[elviejo79]

API

Other

Description

As discussed on discord:
https://discord.com/channels/1196510116388806837/1263654043088322600/1263659074554302515

In bash:
When I execute the command:

$ echo "CREATE (t:Task {title: '1st'}\); Match (t:Task) RETURN t;" | kuzu ./my_todos.kuzudb

I get an output like:

Opened the database at path: ./my_todos.kuzudb in read-write mode.
Enter ":help" for usage hints.
-
(0 tuples)
(0 columns)
Time: 0.85ms (compiling), 25.13ms (executing)
------------------------------------------------------
| t                                                  |
------------------------------------------------------
| {_ID: 0:0, _LABEL: Task, id: 0, title: 1st} |
------------------------------------------------------

Which has too much decoration to be easy to parse.

I would like some output command.
So that I can receive the results as CSV, TSV, or even better JSON.
to use Kuzu as part of bash scripts.

in the mean time...
I can either clean the output by "hand"
or script in python.

[andyfengHKU]

Hi @elviejo79, just let u know issue is solved in #4053 and should be available in our nightly build