Is your feature request related to a problem or challenge? Please describe what you are trying to do.
PostgreSQL (and many others) allow WITH statements to take a list of column aliases right after the CTE name.
WITH numbers(a, b, c) AS (
SELECT 1, 2, 3
)
SELECT * FROM numbers;
DataFusion:
+----------+----------+----------+
| Int64(1) | Int64(2) | Int64(3) |
+----------+----------+----------+
| 1 | 2 | 3 |
+----------+----------+----------+
PostgreSQL:
a | b | c
---+---+---
1 | 2 | 3
Describe the solution you'd like
DataFusion could also support this syntax, considering sqlparser-rs already parses and relays all the relevant information.
Describe alternatives you've considered
None
Additional context
None
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
PostgreSQL (and many others) allow
WITHstatements to take a list of column aliases right after the CTE name.DataFusion:
PostgreSQL:
Describe the solution you'd like
DataFusion could also support this syntax, considering sqlparser-rs already parses and relays all the relevant information.
Describe alternatives you've considered
None
Additional context
None