Query Language (YQL)

select <fields> from <sources> where <condition> [order by <fields>] [limit <n>] [offset <n>] [timeout <ms>]

select * from sources * where title contains "vespa"

select * from sources * where 
  title contains "vespa" 
  and description contains "search" 
  or category contains "database"
  and !(status contains "deprecated")

// Exact match
select * from sources * where price = 100

// Range query
select * from sources * where range(price, 50, 200)

// Less than / Greater than
select * from sources * where price < 100 and rating > 4.5

// Return all fields
select * from sources *

// Return specific fields
select title, price, rating from sources *

// Return document ID only
select documentid from sources *

select * from sources * 
where title contains "vespa" 
order by price desc, rating asc

select * from sources * 
where title contains "vespa" 
limit 20 offset 40

select * from sources * 
where weakAnd(title contains "vespa", description contains "search") 
limit 10

select * from sources * 
where title contains ({stem: false, ranked: false}"Vespa")

select * from sources * where userQuery()

select * from sources * 
where userQuery() and range(price, 0, 100)

select * from sources * 
where title contains "vespa" 
timeout 5000

// Query all sources
select * from sources *

// Query specific schema
select * from product

// Query multiple schemas
select * from sources product, review

select * from sources * 
where title contains "vespa" 
| all(group(category) each(output(count())))