[I] MSSQL: Clarify Synapse final-column trailing-comma support [datafusion-sqlparser-rs]

["dvasdekis (via GitHub)" <gi...@apache.org>]

dvasdekis opened a new issue, #2605:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/2605

   MSSQL: Clarify Synapse final-column trailing-comma support
   
   Should MsSqlDialect have a narrowly scoped capability for a final comma after a complete CREATE TABLE column definition?
   
   Synthetic reproducer:
   ```sql
   CREATE TABLE #example (
       id INT,
       label VARCHAR(32),
   );
   ```
   
   The default MSSQL parser rejects this. The proposed scope is Azure Synapse serverless SQL pool temporary tables, not every SQL Server variant.
   I have not independently executed this reproducer against that service. The documented CREATE TABLE grammar does not clearly establish this allowance, so I am requesting scope confirmation before proposing a default dialect change.
   
   Reference: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=azure-sqldw-latest
   
   If supported, the capability should apply only after a complete final column definition, without enabling global trailing commas, malformed/doubled commas, or trailing function arguments. Existing explicit ParserOptions behavior should remain unchanged.
   Related generic trailing-comma support exists in #1212; this question concerns a narrow default capability and engine scope.
   
   Prepared with GitHub Copilot assistance. All material above is synthetic.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org