- Storage policy now matches the current QuestDB spec: the four stages are
TO PARQUET,TO REMOTE,DROP LOCAL,DROP REMOTE. AddedTO REMOTE(grammar,StoragePolicy.toRemoteAST field,toSql, autocomplete). Removed the unsupportedDROP NATIVEstage and theStoragePolicy.dropNativefield —DROP NATIVEis now a parse error. 08688b6
storage_policies()registered as a table-valued (meta) function. 08688b6
- Long-form TTL / storage-policy values now parse faithfully:
1e9 DAYSno longer collapses to1and.5 DAYSno longer becomesNaN(parseInt→parseFloat,_separators still honored). The server remains the validator. 08688b6
- emit singular time units from toSql 35982c8
- support storage policy 1ccfa5f
- add strict position tracking, prevent equals operator in DECLARE assignments 49b4f58
- Autocomplete hides
pg_*functions (and thepg_catalog.*namespace) until the user has typed apgprefix, sopno longer floods completions with PostgreSQL-compat names. 58a911a
- Named
WINDOWclause:SELECT ... WINDOW w AS (...)with multiple windows, window inheritance, and inline-plus-named mixing. Matches QuestDB's Java parser (introduced in questdb/questdb#6746). #24 - Trailing comma accepted in select lists:
SELECT a, b, FROM tnow parses cleanly. #24
- Named window reference in
OVER wno longer loses the window name when round-tripping through the AST andtoSql. #24 - Autocomplete no longer hangs on malformed input (unbalanced parens, unsupported clauses, stray terminators). A path-count budget in the content-assist DFS aborts pathological searches in <200ms and returns no suggestions, instead of freezing the UI. #24
WINDOWkeyword now shows up in autocomplete as a standalone clause keyword alongsideWINDOW JOINafter aFROMclause. #24
- Position-aware autocomplete: functions are categorized into scalar / aggregate / window / table-valued buckets, remove implicit select filter. 5a422b0
- Add
timestamp_sequence_nsfunction #21 array_elem_min,array_elem_max,array_elem_sum,array_elem_avg,now_ns,systimestamp_ns,rnd_timestamp_nsfunctions #19
- LATERAL JOIN support:
{INNER|LEFT|CROSS} JOIN LATERAL (subquery)and standaloneFROM t, LATERAL (subquery)6e5e5e7 - UNNEST support including JSON UNNEST 6e5e5e7
- PARQUET column config in CREATE/ALTER table statements 6e5e5e7
- remove quoted identifier suppression #17
boost expression operators over clause keywords in WHERE context #15
- Compound JOIN suggestions: suggest "LEFT JOIN", "ASOF JOIN" etc. as single completions instead of bare keywords #13
- CTE grammar: extract
selectBodyrule so DECLARE/WITH are not suggested after WITH clause #13
- Table suggestion ranking: tables no longer interleave with columns in autocomplete #13
- horizon join support #9
- Prioritize tables with mentioned columns in the suggestions #6
- grammar-level table/column classification, join-specific suggestions #2
- Initial release