For a tool offering a SQL-like query and update language for CSV, TSV, LTSV, JSON, and fixed-width data files, readers should check out csvq. Users can extract subsets of the data using the familiar SELECT ... WHERE syntax; generate summaries with aggregate functions such as COUNT, AVG, MEDIAN, and others; or transform the structure of a data file with ALTER TABLE statements. Multiple operations...

Dasel (short for "data selector") is a data query and editing tool that provides a uniform syntax for working with multiple document formats. The platform currently supports JSON, YAML, TOML, XML, and CSV. In the dasel documentation, users can locate a detailed reference manual describing the query syntax. A number of examples are provided that show a set of dasel selectors for common tasks (e.g.,...