LogicalPlan COPY TO statement support

[metesynnada]

Is your feature request related to a problem or challenge?

I want to be able to use

Statement::Copy {
                table_name,
                columns,
                to,
                target,
                options,
                legacy_options,
                values
            }

in the logical plan, from SQLParser. It is mentioned in #5076 and #5130.

Describe the solution you'd like

Add a logical plan enum for this operator that supports the statement::copy fields.

Describe alternatives you've considered

NA

Additional context

NA

[alamb]

This is included in #6313

[alamb]

I plan a PR for this shortly

[alamb]

Proposed PR: #6355