Commands - notshi/dquery GitHub Wiki

You can more or less figure out what a query does by reading it like a sentence.
And just like a sentence, you can write out a whole query in a single line as linebreaks in these examples are mostly for legibility purposes.

The following lists the most common SQL clauses and operators you can use to create queries.

Commands	What it does
select	Picks fields that contain data of interest
from	For dQuery, this is usually xson
where	Limits the data set we are working with
and	Additional limits
or	Additional limits
not	Additional limits
like	Use with % or _
ilike	Use with % or _
as	Use this to name columns
in	Specifies multiple values
group by	Aggregates values across row
order by	Specifies sorting of results with option for asc or desc
limit	Limits the number of returned results
offset	Skips a given number of results
join	Get data from 2 or more tables