Nearly every analytics database uses some dialect of ANSI SQL. ClickHouse now uses the PostgreSQL dialect, as does Amazon Redshift (based on a Postgres fork). M

Nearly every analytics database uses some dialect of ANSI SQL. ClickHouse now uses the PostgreSQL dialect, as does Amazon Redshift (based on a Postgres fork). Microsoft Synapse, of course, uses the MS SQL Server dialect. A third standard, more common than either MySQL or PostgreSQL, is Apache Calcite, which is the SQL dialect used by a wide range of Apache projects (Apex, Beam, Drill, Druid, Flink, Hive, Kylin, Phoenix, Pinot, Samza, Storm), Alibaba MaxCompute, Dremio, OmniSci, Qubole, SQLl-Gremlin, Tencent Big Data Suite, and others. Teradata and Google BigQuery use their own SQL dialects.