SQL-like query language for csv

Insert Query

Insert query is used to insert records to a csv file.

Insert Values

[WITH common_table_expression [, common_table_expression ...]]
  INSERT INTO table_name
  [(column [, column ...])]
  VALUES row_value [, row_value ...]

common_table_expression: Common Table Expression
table_name: identifier or Table Object
column: field reference
row_value: Row Value

Insert From Select Query

[WITH common_table_expression [, common_table_expression ...]]
  INSERT INTO table_name
  [(column [, column ...])]
  select_query

common_table_expression: Common Table Expression
table_name: identifier or Table Object
column: field reference
select_query: Select Query