syntax و قواعد FlovaQL

[TIMEZONE '<IANA>'] SELECT <expressions> FROM <dataset>
[JOIN <dataset> [AS <alias>] [ON <condition>]]
[WHERE <condition>]
[GROUP BY <expressions>]
[HAVING <condition>]
[ORDER BY <expressions>]
[LIMIT <integer>]

SELECT bucket(time, 1h) AS hour, avg(value) AS average_value
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 24h
GROUP BY hour
ORDER BY hour ASC
LIMIT 24

SELECT id, name
FROM devices
WHERE (status = 'offline' OR status = 'unknown')
  AND name LIKE 'lab%'
ORDER BY name ASC
LIMIT 100

SELECT bucket(time, 1h) AS hour, count(value) AS samples
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 7d
GROUP BY hour
ORDER BY hour ASC
LIMIT 168

TIMEZONE 'UTC'
SELECT bucket(time, 1d) AS day, avg(value) AS average_value
FROM telemetry
WHERE datastream.key = 'temperature'
  AND time > now() - 30d
GROUP BY day
ORDER BY day ASC
LIMIT 30

SELECT id, name, status
FROM devices
WHERE device_template_id = $templateId
ORDER BY name ASC
LIMIT 100