add create table comment on table clause to table spec

[Allam76]

In the current version comments on columns are passed on to the create statement api. Comment on the table itself is not. It is parsed in the AST but not carried over to the table spec.

Could it be possible to implement that? I guess a string map to the table spec structure in ddl.go should do it,

Example sql from google:

CREATE TABLE example (
  example_column INT COMMENT "This is an example column",
  another_column VARCHAR COMMENT "One more column"
) COMMENT="This is a comment about table";

It is the last comment "This is a comment about table" that is missing
Many thanks
Martin

[fulghum]

Hi @Allam76, thank you for reaching out with this enhancement request. I moved this issue over to the dolt repo issue queue, since we want to support table level comments in Dolt, and that work will require support in GMS, as well as additional changes in Dolt. I just posted an update this morning with some progress, and I'm hoping to have the initial support out for review later today.

I'm going to resolve this issue in the GMS issue queue, since we're tracking the issue in the Dolt issue queue, and that captures the same work.

Thank you for the enhancement request! We're making active progress on it, so keep an eye out on dolthub/dolt#7416 for more updates.