Accept User Settings for File Formats in CREATE Query for S3 Tables

Why it matters

This feature enables users to customize file format settings when creating external tables that read from S3 storage. It solves the problem of lacking flexibility in configuring file-specific options at table creation time, improving usability and control over how data is interpreted from S3.

How to use it

When creating an S3 table, include the desired file format-related user settings within the SETTINGS clause of the CREATE query. For example:

CREATE TABLE s3_table (...) ENGINE = S3(...) SETTINGS <user_format_settings>;