csv-sql

A node-based tool for running SQL queries on CSV files. This project currently has somewhat limited functionality, and was mainly created as a way to learn more about SQL implementation. For a similar tool with more features, try q - Text as Data.

Version 0.1 Checklist

• Literal identifiers using back-ticks.
• Correct operator precedence.
• Correct handling of NULL, following three-valued logic, including the IS and IS NOT operators.
• LIKE operator.
• GROUP BY.
• Aggregate functions.
• COUNT(*) (synonym for COUNT(1)).
• HAVING.
• CASE.
• IN operator.
• More built-in functions.
• Improved error messages.
• Reading input from stdin, rather than a file.

Future

• DISTINCT.
• User-defined functions provided through node modules.
• Joins.
• Compiling expressions into JS functions using new Function. This should give a very large speed up over the current AST interpreter approach.