gistfile1.md

student {
    name
}

select now()

Anonymous Table Declarations!

in development branch (but working)

-> { now() }

Write Queries!

The difference between insert syntax and update syntax is if you're filtering criteria

Insert query:

<- student {
    name <- 'John'
}

insert into student (name) values ('John')

Update query:

Having a where clause implies that this is an update query

<- student {
    lname <- 'Doe'
    where name = 'John' 
}

update student set lname = 'Doe' where name = 'John'

Inserting multiple records:

<- student {
    name <- ('John', 'Frank'),
    lname <- ('Doe', 'Lin')
}

insert into student (name, lname) values ('John', 'Doe'), ('Frank', 'Lin')

also need to add DEFAULT keyword for this