How to implement function with named args?

[Xuanwo]

I want to implement a function like this:

infer_schema(
    location=>'@mystage',
    file_format=>'my_parquet_format'
)

• How can I implement this kind of in the new expression framework?
• How to do async jobs here? Use GlobalIoRuntime.block_on?

cc @andylokandy @sundy-li for comments

related to #6345

[andylokandy]

Are there many of them?

[Xuanwo]

No, only one so far.

[Xuanwo]

By using named args, we can extend the inputs without breaking users. For example:

infer_schema(
    location=>'@mystage',
    connection = ( endpoint_url='https://example.com' )
    file_format=>'my_parquet_format'
)

Maybe it's not a good idea to be designed as a function?

We also want to support create table via infer_schema, for example:

create table mytable
  using template (
    select array_agg(object_construct(*))
    within group (order by order_id)
      from table(
        infer_schema(
          location=>'@mystage',
          file_format=>'my_parquet_format'
        )
      ));

If it possible if we implement infer_scehma as a SQL statement?

[Xuanwo]

Current design: #8645

[andylokandy]

seems like you can add a new expr element to ast, and then desugar it to function call in the binder.