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.
- Literal identifiers using back-ticks.
- Correct operator precedence.
- Correct handling of
NULL, following three-valued logic, including theISandIS NOToperators. -
LIKEoperator. -
GROUP BY. - Aggregate functions.
-
COUNT(*)(synonym forCOUNT(1)). -
HAVING. -
CASE. -
INoperator. - More built-in functions.
- Improved error messages.
- Reading input from stdin, rather than a file.
-
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.