AlaSQL/alasql ? reverse-engineered prompt
Reverse engineered prompt
Build me a JavaScript SQL library that works in both the browser and Node.js.
I want to be able to run SQL like create table, insert, select, join, group by, order by, and use it on normal tables as well as arrays of objects and nested JSON data. It should feel fast for in memory queries, and it should let me store, import, and export data from things like CSV, JSON, Excel files, localStorage, and IndexedDB.
Please include a simple way to call it with SQL strings, plus examples for working with plain arrays and spreadsheet files. I’d also like a small command line entry point if that fits naturally, and clear docs or examples showing the main use cases.
If you need to, look up the current docs online for the SQL features and file formats it should support. Also make sure it runs cleanly with tests.
Are you gonna build this?
make sure you review the code using coderabbit