Data Query

        {
    select: {
        from: name,     // table or view name
        fields: [],     // fields name
        where: [        // data filter conditions
            {
                left: field_name,   // field name
                opr: operator,      // operator i.e. = > < like
                right: value        // comparable value
            }
        ],
        limit: number,              // maximum number of rows can be returned
        offset: number,             // number of rows skipped from begining
        orderBy: [
            {
                field: field_name,  // sort by field name
                order: asc | desc,  // ordering 
            }
        ]
    }
}        

      

        {
    insert: {
        into: name,     // table or view name
        entry: {        // pairs of field name and value in a data row
            field1: value1,
            field2: value2,
            ...
        },      
    }
}        

      

        {
    update: {
        into: name,     // table or view name
        doc:  doc_id,   // id of the updating data row
        entry: {        // pairs of field name and value in a data row
            field1: value1,
            field2: value2,
            ...
        },      
    }
}  

      

        {
    delete: {
        from: name,     // table or view name
        doc:  doc_id,   // id of the deleting data row
    }
}