QuestDB Cheatsheet (In Progress)

The full cheatsheet will cover:

• Basics: SELECT / WHERE / ORDER BY differences from standard SQL
• Time handling: SAMPLE BY 1s, fill(previous), timezone conversion
• Window functions: FIRST / LATEST / NTH_VALUE / PERCENTILE
• Special joins: ASOF JOIN (time-series alignment), JOIN BY
• Data types: SYMBOL vs VARCHAR — performance and use cases
• ILP ingestion: line protocol syntax, LIN encoding, batch writes
• Partitioning: PARTITION BY DAY / MONTH — query and storage impact

Cheatsheet is in progress and expected to go live within 2 weeks.