AWS SimpleDB Query Builder
This is a tested, working query builder that supports the current spec of simpledb.
How to use
Quick start
TypeScript example:
; Query.select'foo' .from'bar' .wherePredicate.and .orderBy'itemName()', Order.DESC .limit10 .toQueryString;// select `foo` from `bar` where (`baz` != 'a') and (`qux` = 'b' or `qux` = 'c') order by itemName() desc limit 10
JavaScript (node) example:
var qb = ; qbQuery ;// select `foo` from `bar` where (`baz` != 'a') and (`qux` = 'b' or `qux` = 'c') order by itemName() desc limit 10
Supported queries
and([predicate1, predicate2...])
or([predicate1, predicate2...])
not(predicate) // not(predicate)
intersect([predicate1, predicate2...])
every(predicate) // every(attr)...
eq(attr, value) // attr = value
ne(attr, value) // attr != value
like(attr, value) // attr like value
notLike(attr, value) // attr not like value
between(attr, lb, ub) // attr between lb and ub
isNull(attr) // is null
notNull(attr) // is not null
isNull(attr) // is null
valueIn(attr, [value1, value2...]) // attr in (value1, value2...)