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: #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 https://github.com/partiql/partiql-lang-kotlin/pull/1592, I didn't account for dotted targets in https://github.com/partiql/partiql-lang-kotlin/pull/1592 either, darnit. (record dml_target (identifier identifier)) should have been (record dml_target (* (identifier identifier) 1)).