SQL-like query language for csv

Flag

A flag is a representation of a command option.

Flags

name type description
@@REPOSITORY string Directory path where files are located
@@TIMEZONE string Default TimeZone
@@DATETIME_FORMAT string Datetime Format to parse strings
@@ANSI_QUOTES boolean Use double quotation mark as identifier enclosure
@@WAIT_TIMEOUT float Limit of the waiting time in seconds to wait for locked files to be released
@@IMPORT_FORMAT string Default format to load files
@@DELIMITER string Field delimiter for CSV
@@DELIMITER_POSITIONS string Delimiter positions for Fixed-Length Format
@@JSON_QUERY string Query for JSON data
@@ENCODING string Character encoding
@@NO_HEADER boolean Import first line as a record
@@WITHOUT_NULL boolean Parse empty fields as empty strings
@@STRIP_ENDING_LINE_BREAK boolean Strip line break from the end of files and query results
@@FORMAT string Format of query results
@@WRITE_ENCODING string Character encoding of query results
@@WRITE_DELIMITER string Field delimiter for query results in CSV
@@WRITE_DELIMITER_POSITIONS string Delimiter positions for query results in Fixed-Length Format
@@WITHOUT_HEADER boolean Write without the header line in query results
@@LINE_BREAK string Line Break in query results
@@ENCLOSE_ALL boolean Enclose all string values in CSV
@@JSON_ESCAPE string JSON escape type of query results
@@PRETTY_PRINT boolean Make JSON output easier to read in query results
@@EAST_ASIAN_ENCODING boolean Count ambiguous characters as fullwidth
@@COUNT_DIACRITICAL_SIGN boolean Count diacritical signs as halfwidth
@@COUNT_FORMAT_CODE boolean Count format characters and zero-width spaces as halfwidth
@@COLOR boolean Use ANSI color escape sequences
@@QUIET boolean Suppress operation log output
@@LIMIT_RECURSION integer Maximum number of iterations for recursive queries
@@CPU integer Hint for the number of cpu cores to be used
@@STATS boolean Show execution time

SET FLAG

SET @@flag_name TO value;
SET @@flag_name = value;
value
value or identifier

A Set Flag statement is used to overwrite the flag value passed by using the command option.

@@DATETIME_FORMAT flag is appended to the current formats, not overwritten.

SHOW FLAG

SHOW @@flag_name;

A Show Flag statement outputs the flag value.

ADD FLAG ELEMENT

ADD value TO @@DATETIME_FORMAT;
value
string

A Add Flag Element statement is used to add datetime formats to @@DATETIME_FORMAT.

You can use JSON array of strings to set multiple format at once.

REMOVE FLAG ELEMENT

REMOVE value FROM @@DATETIME_FORMAT;
value
string or integer

A Remove Flag Element statement is used to remove a format from @@DATETIME_FORMAT.

If value is a string, then the same element in the @@DATETIME_FORMAT is removed. If value is an integer, then an element existing at the index number is removed.