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 #17451 (comment)

[lmatz]

• Insert by name

[lmatz]

• Dynamic PIVOT and UNPIVOT

[lmatz]

• List lambda functions

Supported by #11937. Beware of the complications it troduced: #11937 (comment) #13724

[lmatz]

• List comprehensions

[lmatz]

• Exploding struct.*

See #10847 and #6934 (comment)

[lmatz]

• Automatic struct creation

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

[lmatz]

• Union data type

[github-actions]

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.