Athena SHOW parsing for DDL statements

[theborch]

Is your feature request related to a problem? Please describe.

Not so much a problem, but would like to add parsing for SHOW statements in the athena dialect.

Example:

from sqlglot import parse_one

parse_one("show create table db.table", dialect="athena")

Output:

'show create table db.table' contains unsupported syntax. Falling back to parsing as a 'Command'.
Command(
  this=SHOW,
  expression=Literal(this=create table db.table, is_string=True))

Describe the solution you'd like

Desired Output:

Show(
  this=CREATE TABLE,
  target=Identifier(this=table, quoted=False),
  db=Identifier(this=db, quoted=False))

Describe alternatives you've considered

Alternatives would be adding SHOW parsing to Hive/Trino dialects, but Athena has a specific subset of SHOW statements, so figured it best to start there.

Additional context

#4703 Submitted as possible solution.

[georgesittas]

Closing this for now as the core team doesn't plan to address this. It should be closed "as completed" if/when the linked PR is in.