Hello, everyone in the Calcite community. Calcite currently does not emphasize the version or even the adapter adaptation for the adaptation of various database dialects, but as more and more dialects are adapted, this may become a hidden danger. For example, a database modifies a certain syntax in a certain version, but Calcite has already adapted the previous syntax, then do we still need to be compatible with the modified syntax? There are many similar examples, such as adaptation functions, etc.
I think we can find a way to determine a standard, describe it in the document and tell users, such as determining it according to the latest version, or do you have better suggestions? Best wishes, Cancai Cai