Let's start with a simple Delia program:
type Message struct {
message string
} end
insert Message {'Hello World'}
let msg = Message[true] //query all Messages
This program defines a type Message, stores it in the database and then queries it back. Delia will execute the following SQL:
CREATE TABLE Message (
message VARCHAR(4096)
);
INSERT INTO Message (message) VALUES ('Hello World');
SELECT * FROM Message;
The result will be:
> Message [
{ message: 'Hello, World'}
]