Although it has its gotchas, MySQL dialect is still somewhat better from the usability standpoint. "SHOW TABLES" is nice; it is natural and self-explanatory. "\

Although it has its gotchas, MySQL dialect is still somewhat better from the usability standpoint. "SHOW TABLES" is nice; it is natural and self-explanatory. "\d" is obscure. It also reminds me how many DBMSs did not support the LIMIT clause because it is non-standard. But it is good from a usability perspective. https://stackoverflow.com/questions/1528604/how-universal-is-the-limit-statement-in-sql https://stackoverflow.com/questions/1528604/how-universal-is... That's why ClickHouse has support for most of the extensions from the MySQL dialect.