Referring to the configuration section of datafusion docs. I was thinking if we should allow the end users to set options on the roapi server level set options like change of dialect etc.

This would look something like the below in the YAML config.

addr:
    ...

tables:
    ...

configuration:
    datafusion:
        sql_parser.dialect: "Hive"
        explain.physical_plan_only: true
        ...