Skip to content

Some query/export formats fall back to default output instead of specified format #8

@teaguesterling

Description

@teaguesterling

Description

Several format options for the query and export tools don't produce the expected output format, instead falling back to a default tab-separated format with type headers.

Affected Formats

Query Tool

  • jsonl - Returns tab-separated instead of JSON Lines
  • table - Returns tab-separated instead of ASCII table
  • box - Returns tab-separated instead of box-drawing table

Export Tool

  • jsonl - Same issue as query tool
  • table / box - Same issue as query tool

Working Formats

  • json
  • markdown
  • csv

Example

SELECT * FROM users

With format: "jsonl", expected:

{"id":"1","name":"Alice","email":"alice@example.com"}
{"id":"2","name":"Bob","email":"bob@example.com"}

Actual:

id	name	email	created_at	
INTEGER	VARCHAR	VARCHAR	DATE	
[ Rows: 4]
1	Alice	alice@example.com	2024-01-15
2	Bob	bob@example.com	2024-02-20

Notes

  • parquet format for export also falls back to tab-separated, but parquet is a binary format so it doesn't make sense as a text return value anyway. Consider removing it as an option or only supporting it when an output file path is specified.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions