QuestDB 9.3: Window joins, views, PIVOT, and AI in the console

QuestDB 9.3 introduces significant enhancements to its open-source time-series database, catering to demanding workloads with ultra-low latency and high ingestion throughput. This release features four major additions: window joins, views, PIVOT functionality, and AI-assisted workflows. Window joins allow for efficient correlation of events with surrounding time data, while views offer reusable query logic with customizable parameters. The PIVOT keyword transforms rows into columns, facilitating multi-dimensional reporting and dashboard integration. AI assistance is integrated into the Web Console, enabling users to leverage language models for tasks like SQL writing and query debugging. Additionally, the update includes performance improvements such as column projection pushdown for Parquet, parallel sorting for ORDER BY clauses, and optimized min/max queries on timestamp columns, enhancing execution speed significantly. Overall, QuestDB 9.3 expands both the expressive power and user interaction capabilities of the database, while also enhancing its core performance.