SQL-like query language for csv

Row Value

A Row Value is a ordered list of values.

row_value
  : (value [, value...])
  | (select_query)
  | JSON_ROW(json_query, json_data)
value
value
select_query
Select Query

Retrieved fields of select_query are used as listed values. The result set of select_query must have at most one record.

json_query
JSON Query

Empty string is equivalent to “[]”.

json_data
string

Row Values can be used in limited operation such as Comparison Operation or Insert Query. In most cases, a row value with a single value is interpreted as a value with parentheses.