Discussion: "Even Friendlier SQL with Risingwave"

[lmatz]

A lot of user-friendly and innovative ideas from Even Friendlier SQL with DuckDB But maybe not all of them are suitable for RW, let's have a discussion.

Welcome leave comments (pro/con) for the syntax and give it a 👍 or 👎

[lmatz]

• [ ] Reusable column aliases

[lmatz]

• [ ] COLUMNS() with except and replace

[lmatz]

• [ ] COLUMNS() with regular expressions

[lmatz]

• [ ] Automatic JSON to nested types conversion

[lmatz]

• [ ] FROM first in SELECT statements

[lmatz]

• [ ] Function chaining

[lmatz]

• [ ] Union by name

The SQL 92 standard uses CORRESPONDING instead of BY NAME https://github.com/risingwavelabs/risingwave/issues/17451#issuecomment-2191639814

[lmatz]

• [ ] Insert by name

[lmatz]

• [ ] Dynamic PIVOT and UNPIVOT

[lmatz]

• [x] List lambda functions

Supported by #11937. Beware of the complications it troduced: https://github.com/risingwavelabs/risingwave/pull/11937#discussion_r1309719284 #13724

[lmatz]

• [ ] List comprehensions

[lmatz]

• [ ] Exploding struct.*

See #10847 and https://github.com/risingwavelabs/risingwave/issues/6934#issuecomment-1396344815

[lmatz]

• [ ] Automatic struct creation

Also part of PostgreSQL. See the same 2 issues linked under Exploding struct.*

[lmatz]

• [ ] Union data type

[github-actions[bot]]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.