Liking cljdoc? Tell your friends :D

SQL Features

Filtering

Parameters should be placed under query arguments as below:

where: {column-a: {operator: value} column-b: {operator: value}}

AND / OR group can be created as clause lists in and / or parameter under where. It is possible to nest them to create sub group of conditions such as ((a=1 AND b=2) OR (a=3 AND b=4)).

  • Supported operators are eq, ne, gt, lt, gte, lte, in and like.
  • Multiple filters are applied with AND operator.
Example:

Users where name is like ken AND age is 20 OR 21.

{users (where: {name: {like: "%ken%"} or: [{age: {eq: 20}}, {age: {eq: 21}}]})}

Sorting

Parameters should be placed under query arguments as below:

sort: {[column]: [asc or desc]}
Example:

Sort by id column in ascending order.

sort: {id: asc}

Parameters should be placed under query arguments as below:

limit: [count]
offset: [count]
  • limit and offset can be used independently.
  • Using offset can return different results when new entries are created while items are sorted by newest first. So using limit with id filter or created_at filter is often considered more consistent.
Example:

25 items after/greater than id:20

(where: {id: {gt: 20}} limit: 25)

Aggregation

avg, count, max, min and sum are supported and it can also be filtered.

Example:

Select count of cart_items together with max, min sum and avg of price where cart_id is 1.

cart_items_aggregate (where: {cart_id: {eq: 1}}) {count max {price} min {price} avg {price} sum {price}}

Can you improve this documentation?Edit on GitHub

cljdoc is a website building & hosting documentation for Clojure/Script libraries

× close