Allow Default Table Engine and Create Tables Without Specifying ENGINE

Why it matters

This feature addresses the need to simplify table creation by removing the mandatory requirement to specify a table engine each time. It streamlines workflows and reduces boilerplate for users who consistently use the same table engine, improving usability and configuration management.

How to use it

Users can configure a default table engine in the ClickHouse server settings. Once set, tables can be created without providing the ENGINE clause in their CREATE TABLE statements, and the configured default engine will be automatically applied.