Support for INSERT INTO <qualified identifier>

[johnedquinn]

Requested Solution/Feature

• Several of the DDL and DML statements don't allow for qualified identifiers. This ticket is specifically asking for support for insert statements with qualified identifiers.
• The following should parse:

INSERT INTO some_catalog."some_SCHEMA".some_table VALUES (1, 2, 3);

• Also, the experimental planner implementation should add planning support for this.

Additional Context

• The AST and plan modeling on main currently do not have support for qualified identifiers. This should be addressed as part of this issue.
• There is likely significant reworking of the definition of bindings. This is already handled on the v1 branch, however, this request is for main's experimental planner implementation.
• This originally came as a request relevant to: Add dml update to partiql_logical pig domain and improve DML modeling #1592

DoD (Definition of Done)

• AST and plan modeling adding support for qualified identifiers
• Parser support for INSERT INTO <qualified identifier>
• Planner support for qualified identifiers

[hpolloni]

Hey, although we would like to have planner and parser support for this feature. I think that at least fixing the grammar to support qualified identifiers would be a great first step.

[dlurton]

In #1592, I didn't account for dotted targets in #1592 either, darnit. (record dml_target (identifier identifier)) should have been (record dml_target (* (identifier identifier) 1)).