Experimental, very limited api

Working features

• Select
• Basic where clauses
• Insert

Features in development

• More capable where clauses
• Update
• Delete
• Join

Select Queries

Queries are natural language and can be presented in a number of ways.

(select|get|find|fetch|read) (my|the)? #Column (and|with|plus|along with|include|including|also) #Column (from|in|out of) the? (my|the)? #Table table?

• “Select id and tags from Words”
• “Find my Id and Tags in my words table”
• “Get my Tags from the Words table”
• “Read the tags in my Words table”

Where Clause

Basic where clauses are supported that perform “contains” checks for string matching. I’ll add <, >, =, and != later.

where #Column and #Column contain

• “Select id and tags from Words where Tags contain (cosine)”
• “Select id and tags from Words where Tags and word contain (Trig, cos)”

Insert Queries

Insert queries use parentheses to wrap the row to be inserted, the row ID is an auto generated uuid.

(add|insert|create) (row|value|entry|values)? (into|add to|insert into|to)? #Table

• “Insert (someWord,someTag) into Words”
• “Add row (someWord,someTag) to Words”
• “Create entry (someWord,someTag) add to Words”

Delete Queries

(remove|delete|erase) (from|row|entry|rows|entries) (from|the|out of)? #Table

• “Remove from Words where tags contain (physics)”
• “Erase entries from Words where tags contain (physics)”

---