SELECT

[WITH cte AS (...)]
SELECT [ALL | DISTINCT] select_expr [, ...]
FROM from_item [[JOIN ...] ON ...]
[WHERE predicate]
[GROUP BY expr [, ...]] [HAVING predicate]
[WINDOW name AS (...)]
[ORDER BY expr [ASC | DESC] [NULLS FIRST | LAST] [, ...]]
[LIMIT n] [OFFSET n]

SELECT id, title, identifier FROM documents

tbl.search().select(["id", "title", "identifier"]).to_arrow()

await tbl.query().select(["id", "title", "identifier"]).toArrow();

SELECT * FROM documents
WHERE identifier > 0 AND identifier < 1000000

tbl.search().where("identifier > 0 AND identifier < 1000000").to_arrow()

await tbl.query().where("identifier > 0 AND identifier < 1000000").toArrow();

SELECT id, title FROM documents
ORDER BY created_at DESC NULLS LAST
LIMIT 100 OFFSET 200

SELECT id FROM documents WHERE category = 'film'
UNION ALL
SELECT id FROM archived_documents WHERE category = 'film'

WITH recent AS (
    SELECT * FROM documents WHERE created_at > now() - INTERVAL '7 days'
)
SELECT category, count(*) FROM recent GROUP BY category

SELECT title
FROM documents
WHERE category_id IN (SELECT id FROM categories WHERE active)

SELECT * FROM `prod$events`.clicks

EXPLAIN ANALYZE SELECT * FROM documents WHERE identifier < 1000