Grammar

The grammar is in brainstorming phase, and should be changable easily. This is why there is no detailed description for most parts yet.

INSERT test.insert(1,"Hallo")
insert test(id=1, name='Hallo')
insert test(1,'Hallo')
UPDATE
test[id==1].update(name="Hallo")
update test id=1
where name=='Hallo'
DELETE
test[id==1].delete()
delete test where id==1
SELECT
test[id==1].select()
select test where id=1
CREATE TABLE
test=new table(
  autoincrement id,
  string name,
  key(id),
  index(name) idxName
)
create table test(
  id autoincrement,
  name string,
  primary key(id),
  index idxname(name)
)
CREATE INDEX
test.add(index idxName(name))
create index test.idxname(name)
CREATE USER
sys.users.insert("scott","tiger")
create user scott password tiger
GRANT
sys.rights.put("scott","test","all")
grant scott test, all
DROP TABLE
test.drop()
drop test
DROP INDEX
test.dropIndex(idxname)
drop test.idxname
COMMIT
commit()
commit
ROLLBACK
rollback()
rollback
Data types
boolean, int, long, string, date, time, timestamp, binary, decimal, autoincrement
boolean, int, long, string, date, time, timestamp, binary, decimal, autoincrement, stream
Conditions
! || && == >= <= > < !=
not or and == >= <= > < <>
Expressions
+ - ( ) * / & | %
+ - ( ) * /