SQL-like query language for csv

Replace Query

Replace query is used to insert or update records to a csv file.

If records matching key_columns exist, the records are updated. Otherwise insert records.

Insert or Update Values

[WITH common_table_expression [, common_table_expression ...]]
  REPLACE INTO table_name
  [(column [, column ...])]
  USING (key_column [, key_column ...]))
  VALUES row_value [, row_value ...]
common_table_expression
Common Table Expression
table_name
identifier or Table Object
column
field reference
key_column
field reference
row_value
Row Value

Insert or Update From Select Query

[WITH common_table_expression [, common_table_expression ...]]
  REPLACE INTO table_name
  [(column [, column ...])]
  USING (key_column [, key_column ...]))
  select_query
common_table_expression
Common Table Expression
table_name
identifier or Table Object
column
field reference
key_column
field reference
select_query
Select Query