Skip to content

Add an example of how to convert LogicalPlan to/from SQL Strings #10550

@alamb

Description

@alamb

Part of #9494

Is your feature request related to a problem or challenge?

Having a good example helps to make features easier to use in DataFusion

In this case the usecase is programmatic construction of SQL using the DataFUsion LogicalPlan s using the api from #9726

Describe the solution you'd like

Extend the example from @edmondop 's great work in #10528 with the following cases:

  1. Create a plan using the DataFrame API and converting it back to SQL

Bonus points for also adding
3. Parse SQL like SELECT * from foo into a DataFrame, adding a filter, and then converting that back to SQL

Describe alternatives you've considered

Here is an example of creating a dataframe example https://docs.rs/datafusion/latest/datafusion/index.html#dataframe

You can call DataFrame::logical_plan to get the plan

Then call plan_to_sql and demonstrate the SQL that was created

https://github.com/apache/datafusion/blob/842f3933e3496a022984c2a37254475a3bcde1bf/datafusion/sql/tests/sql_integration.rs#L4689C1-L4690C51

Additional context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions