Hello, I am a newbie to Calcite and still trying to figure all the pieces of the project.
In looking for support in Calcite to parse Snowflake expressions I ran into a question asked earlier this month on the dev mail list which is pretty much exactly what I am trying to do. Simon asked the question pretty concisely see https://www.mail-archive.com/[email protected]/msg17417.html. I did not see a follow up after Julian's response on that thread and wanted to ask if there was work in progress on the snowflake integration? I looked at the instructions Julian provided but given that I am new to this project I could not quite follow the pieces so I figured I should ask a few questions to get a better understanding. Apologies if these seem obvious and if they are already covered, please point me to collateral for the same (a) There is a Free Marker template for parser in core as well as babel sub-project. How are these two related? (b) The field reference operator ':' in snowflake (storing json in a variant column) differs from '->>' as used in PostgresDB for jsonb. My thought is that such a reference operator probably should be in a database specific extension like through a snowflake adapter. Is that thinking accurate? (c) How are new data types plugged in? For example VARIANT is a specific Snowflake implementation and probably should stay in a snowflake adapter. Similar to (b). For (b) and (c) how can a newbie like me understand how new operators or data-types get introduced into the parser? Which adapter or example should I look at to get a better sense of how the above is done? Thanks in advance for your help. Sandeep
