kxi query

Execute a SQL query and print results to console/file.

Usage:

text

Copy

kxi query [OPTIONS]

Options:

text

Copy

  --sql TEXT                      The SQL query to be executed  [required]
  --output-format [tabular|csv|json|json_records]
                                  tabular: print query results in tabular
                                  format (default) csv: print query results as
                                  csv json: print query results as columnar
                                  json json_records: print query results as a
                                  json object per row
  --output-file TEXT              Optionally write results to an output_file
                                  instead of console
  --help                          Show this message and exit.