🪟 Full Window Function support: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, NTILE, FIRST_VALUE, LAST_VALUE & more for analytical workloads
🔄 Common Table Expressions including recursive CTEs for complex hierarchical and graph-style data queries
📈 Advanced aggregations: ROLLUP, CUBE & GROUPING SETS for multi-dimensional reporting and subtotal calculations
💾 Write-Ahead Logging (WAL) periodic snapshots for crash-safe persistence – runs in both in-memory and file-based …