Overview

About ql.io

Language Overview

Runtime Overview

Usage Overview

Getting Started

Prerequisites

Quick Start

Build an App

Examples

Build and Develop ql.io!

Writing Scripts

create table

connectors

select

if-else

insert

update

delete

URI Templates

Data Formats

Variable References

Configuration

Script Routes

Monkey Patching

UDF

try-catch-finally

Timeouts and Back-off

OAuth

Executing Scripts

HTTP Interface

WebSocket Interface

Engine API

Caching (Memcache)

Fallback

Conditions

Monitoring

Runtime Monitoring

References

Language Reference

URI Template Syntax Reference

Best Practices Guide

Troubleshooting

Language Reference

The diagrams below describe the syntax of the SQ + JSON flavored DSL of ql.io.

start:

line return

no references

line:

assign comment

referenced by:

assign:

word = statement value ;

referenced by:

statement:

selectStatement showStatement describeStatement insertStatement deleteStatement createStatement

referenced by:

comment:

-- sp [#x0020-#xFFFF] crlf

referenced by:

createStatement:

create table table act

referenced by:

selectStatement:

select columnsClause from fromClause whereClause limit offset

referenced by:

showStatement:

show tables

referenced by:

describeStatement:

describe desc table

referenced by:

insertStatement:

insert in to table ( columnsClause ) values ( csv )

referenced by:

deleteStatement:

delete from table whereClause

referenced by:

act:

on select insert delete update get from post to put to delete uri withAliases usingHeaders usingDefaults usingMonkeyPatch usingBodyTemplate authenticateUsing resultSet

referenced by:

usingDefaults:

using defaults nvps

referenced by:

usingHeaders:

using headers nvps

referenced by:

usingMonkeyPatch:

using patch moduleName

referenced by:

usingBodyTemplate:

using bodyTemplate templateFile type mediaType

referenced by:

withAliases:

with aliases nvps

referenced by:

authenticateUsing:

authenticate auth using moduleName

referenced by:

resultSet:

resultset quotedWord

referenced by:

nvps:

lhs quotedWord = rhs ,

referenced by:

columnsClause:

* fieldName as identifier fieldName ,

referenced by:

fromClause:

table , table

referenced by:

table:

identifier as identifier identifier

referenced by:

whereClause:

where whereCriteria

referenced by:

limit:

limit digits

referenced by:

offset:

offset digits

referenced by:

whereCriteria:

cond and

referenced by:

cond:

eqCond inCond udf

referenced by:

eqCond:

lhs = in rhs

referenced by:

inCond:

identifier in ( selectStatement csv )

referenced by:

udf:

identifier ( aliasedRef quotedWord quotedDigits , )

referenced by:

csv:

quotedWord quotedDigits identifier ,

referenced by:

lhs:

field

referenced by:

rhs:

aliasedRef quotedWord quotedDigits digits

referenced by:

aliasedRef:

selector .

referenced by:

fieldName:

selector .

referenced by:

selector:

word [ digits " qword " ' qword ' ] word

referenced by:

identifier:

word .

referenced by:

word:

[a-z] [A-Z] $ : [a-z] [A-Z] _ [0-9] :

referenced by:

return:

return statement ref json route ;

referenced by:

route:

via route uriPath using method get post put delete patch

referenced by:

value:

json string number array true false null

referenced by:

These diagrams were generated using the Railroad Diagram Generator.