v.22.3Improvement

Allow Opening Empty SQLite DB When File Doesn't Exist

Allow opening empty sqlite db if the file doesn't exist. Closes #33367. #34907 (Kseniia Sumarokova).
Added support to open an empty SQLite database file in ClickHouse if the file does not exist.

Why it matters

This feature addresses the issue where attempts to open a non-existing SQLite database file would fail. By allowing the creation and opening of an empty SQLite database file, users can seamlessly integrate SQLite tables without pre-creating the database file, improving usability and reducing setup steps.

How to use it

When using SQLite integration in ClickHouse, simply specify the path to the SQLite database file. If the file does not exist, ClickHouse will now create and open an empty SQLite database automatically without errors.