✔️ 1. It should use Atomic database engine instead of Memory for the default database, so the metadata will be preserved across runs.

✔️ 2. The default database should be named default instead of _local.

\3. It should use ./clickhouse.local directory as the working directory instead of a random directory in /tmp

\4. Nevertheless, if the directory cannot be created, it should continue working.

✔️ 5. Temporary tables for File IO should use the mechanism of the temporary tables.

✔️ 6. Ideally, it should not create any directories if the queries are purely stateless like SELECT 1.