https://vimeo.com/970059222/aefd4c0943?share=copy
- Would like to get future dialogue as close to Postgres as possible for easier mapping
- Mostly Postgres Dialogue
- Custom SQL functions like array.ag, other functions. Smaller changes that need cross-referencing.
- For new SQL - does it offer similar syntax?
Various SQL Features
| System |
Pinot / StarTrue |
SingleStore |
ClickHouse |
| Window Functions |
yes |
yes |
yes |
| CTE’s |
yes |
|
yes |
| joins |
yes |
|
yes |
Thought Joggers
- CTE Support?
- JSON path syntax (vs Rockset’s dot path)