ByteHouse provides two query modes: ClickHouse and ANSI.
For the ClickHouse mode, most functions are consistent with the community version of ClickHouse, but some self-developed functions are also provided. We will cite some document content from the community to explain the specific differences and how to use them.
For the ANSI SQL mode, this mode offers a comprehensive SQL syntax. In this mode, SQL statements are sent to Apache Calcite for parsing and validation, then sent to the engine for execution. Apache Calcite supports standard ANSI SQL. Please refer to the BNF syntax here for more details: https://calcite.apache.org/docs/reference.html