I'd like to parse ClickHouse SQL which contains parameters for their parameterized views. The SQL looks like
CREATE VIEW view AS SELECT * FROM TABLE WHERE Column1={column1:datatype1}
Note the parameter is in the { } brackets. I don't think this could be implemented in the Dialect as curly braces are tokenized without deferring to the dialect. It would probably have to be handled by the tokenizer as a special case like numbers are for MySQL & Hive.
alamb
commented
7 months ago
I'd like to parse ClickHouse SQL which contains parameters for their parameterized views. The SQL looks like
CREATE VIEW view AS SELECT * FROM TABLE WHERE Column1={column1:datatype1}Note the parameter is in the { } brackets. I don't think this could be implemented in the
Dialectas curly braces are tokenized without deferring to the dialect. It would probably have to be handled by the tokenizer as a special case like numbers are for MySQL & Hive.