columns mismatch

[Pamblam]

inserting breaks when using column names:

create table poops (color varchar(20), stink int)
insert into poops (color, stink) values ("red", 7)

also,

execute() should be chainable on insert queries as well, even though there is nothing to fetch.

[Pamblam]

This was actually caused by the unquoted number not being parsed correctly and that issue has been fixed.

Related: The create table syntax was broken as it relies on objects to maintain their given order, which cannot be guaranteed. This is fixed by using an array instead of an object.

The old signature looked like this:

jSQL.createTable({Users:{
    Name: {type:"VARCHAR", args:[30]},
    Age: {type:"INT", args:[]},
}}).ifNotExists().execute();

The new signature looks like this:

jSQL.createTable({Users:[
    {name:"Name", "VARCHAR", args:[30]},
    {name: "Age", "INT", args:[]},
]}).ifNotExists().execute();

.execute() is now chainable on insert queries as well.