q

Working with tabular data and running SQL queries in them can pose serious difficulties, especially when dealing with large datasets, running multiple iterations, and applying varied SQL constructs.
In order to attain a simplification of the process of implementing tabular data SQL processing into programming or other frameworks that might be running iterative processes, q was developed, and it will offer users a command-line based solution for such tasks.
The tool will deal with tabular files, regardless of their format and arrangement, as database tables and users will be able to implement in their workflow some of the most common SQL constructs and syntax. In terms of the actual text processing, the column defining characteristics, such as the name and type, will be automatically detected by the tool’s algorithms. Furthermore, support for complete encodings is also provided.
Through a series of commands which are readily available and can always be previewed using the command “-h”, users can attain a wide range of tasks. A wide range of encoding types are supported for both the input data and queries and in case novices might be tampering with these, the developer was kind enough to include common defaults for most of the parameters.