Create a struct with the specified field names and values

[yukkit]

Is your feature request related to a problem or challenge?

I want to construct struct from literal or expression by using sql or rust interface.

like:

• https://docs.databricks.com/sql/language-manual/functions/named_struct.html
• https://duckdb.org/docs/sql/data_types/struct.html
• https://www.postgresql.org/docs/current/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS

Describe the solution you'd like

Add a NamedStruct expression similar to what spark does

sql usage:

SELECT named_struct('a', 1, 'b', 2, 'c', 3);

Describe alternatives you've considered

No response

Additional context

If this issue is useful, I will implement it

[crepererum]

Note that there is currently NO way to construct a struct with custom field names, because DF also doesn't support casting structs that were constructed using struct(1, 2, 3). But even if such a workaround would be possible, I think having a direct constructor would still be nice.

[alamb]

There is a PR up to support named_struct #9743 and work afoot to support nicer literal syntax: #9820 🚀