[GitHub] [calcite] PasunuriSrinidhi commented on pull request #3087: [CALCITE-5551]: Support SELECT * Except(column) in parser

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

PasunuriSrinidhi commented on PR #3087:
URL: https://github.com/apache/calcite/pull/3087#issuecomment-1484148506

   > Sometimes it is useful to be able to select all columns in a table except one or two columns.
   > 
   > This is a useful feature in for instance bigquery.
   > 
   > I could not figure out how to make the parser deal with dialects, so I added this to the default parser.
   > 
   > I do not think that this is supported by all databases, so not sure where this should live, please advice.
   
   In your parser code, you can use the value of dialect to determine whether to include certain features or syntax. In the case of selecting all columns except one or two, you could check if the dialect is bigquery, and if so, include the necessary syntax for this feature.
   
   By using a configuration option, users can specify which dialect they are using, and the parser can be modified accordingly without affecting other users who may not be using the same dialect.


-- 
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: commits-unsubscribe@calcite.apache.org

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