AlaSQL / alasql

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.
http://alasql.org
MIT License
7.02k stars 655 forks source link

insert into tbl(fld1, fld2) values(1,2) #1807

Open mathiasrw opened 1 year ago

mathiasrw commented 1 year ago

According to https://github.com/AlaSQL/alasql/discussions/1806#discussioncomment-7091043 alasql does not support

insert into tbl(fld1, fld2) values(1,2)
vamsikrishnacse commented 11 months ago

Hi @mathiasrw can i work on this issue? and can you pls provide me some more information to move forward.

mathiasrw commented 11 months ago

Sure!

Fist, have a look at https://github.com/AlaSQL/alasql/blob/develop/CONTRIBUTING.md and then use the yarn jison command before running yarn test

BUT

the last few months I have had problems with compiling a new jison. Some deep dependencies have been updated and now I cant recreate a version that produces a jison parser that works.

Sooooo - what would be really helpful and first step to this, would be to make sure that yarn jison && yarn test is running. You will see that the version in src/alasqlparser.js is currently 0.4.18 and after recompiling goes to something else (i think its 0.6).

The way forward is to

The fix for b) is the smalles (as its probably a naming thing or something else that is slightly different) but timewise it will probably be faster to go with a). So - it really depends on your appetite for adventure...